Good evening,Please see Excel Formulas and Charts assignment: Excel Formulas and Charts: Assignment...

Question

Good evening,Please see Excel Formulas and Charts assignment:

Excel Formulas and Charts:

Assignment Requirements – turn in an Excel file with a different tab for each part below:

In an Excel file do Problems 1, 2, 4 on pages 74, 75 of the textbook below using the file IQBRAIN.XLS – (link provided below).

In an Excel file do Problems 6, 7 on page 76 of the textbook below using the data in the problem. You have to type in the numbers into an empty worksheet in Excel.

With the data set OSCR.XLS (link provided below), calculate the mean, median, standard deviation, variance, and range using Excel on its own tab. The functions to use are AVERAGE, MEDIAN, STDEV.P, VAR.P, (range = MAX – MIN) for this problem.

Using the same file OSCR.XLS, and using the box-plot.xls template link provided below or that is free fromwww.vertex42.com, create a boxplot of the data for actors and actresses – 2 box plots can be created using the single template. This can be submitted separately from the other Excel file for parts a, b, c.

IQBRAIN.XLS; OSCR.XLS

and BOX-PLOT.XLSX can all be found using this link google drive:

https://drive.google.com/open?id=0BzFQRPAdfPSPVTZVVHpxYjZ3dzA

The problems are in attachment and I will need the assignment completed by April 10, 2019, 9:00PM, EST US Standard. Thank you so much.

Excel Formulas and Charts: Assignment Requirements – turn in an Excel file with a different tab for each part below: a. In an Excel file do Problems 1, 2, 4 on pages 74, 75 of the textbook below using the file IQBRAIN.XLS – (link provided below). b. In an Excel file do Problems 6, 7 on page 76 of the textbook below using the data in the problem. You have to type in the numbers into an empty worksheet in Excel. c. With the data set OSCR.XLS (link provided below), calculate the mean, median, standard deviation, variance, and range using Excel on its own tab. The functions to use are AVERAGE, MEDIAN, STDEV.P, VAR.P, (range = MAX – MIN) for this problem. d. Using the same file OSCR.XLS, and using the box-plot.xls template link provided below or that is free from www.vertex42.com, create a boxplot of the data for actors and actresses – 2 box plots can be created using the single template. This can be submitted separately from the other Excel file for parts a, b, c. IQBRAIN.XLS; OSCR.XLS and BOX-PLOT.XLSX can all be found using this link google drive: https://drive.google.com/open?id=0BzFQRPAdfPSPVTZVVHpxYjZ3dzA a. Problems 1, 2, 4 on pages 74, 75: b. Problems 6, 7 on page 76:

excel-formulas-and-charts-hw-assignment-2-cvpct1go.docx

Rajeswari · Accepted Answer

Sheet1
		Actresses	Actors
		22	44
		37	41
		28	62
		63	52
		32	41
		26	34
		31	34
		27	52
		27	41
		28	37
		30	38
		26	34
		29	32
		24	40
		38	43
		25	56
		29	41
		41	39
		30	49
		35	57
		35	41
		33	38
		29	42
		38	52
		54	51
		24	35
		25	30
		46	39
		41	41
		28	44
		40	49
		39	35
		29	47
		27	31
		31	47
		38	37
		29	57
		25	42
		35	45
		60	42
		43	44
		35	62
		34	43
		34	42
		27	48
		37	49
		42	56
		41	38
		36	60
		32	30
		41	40
		33	42
		31	36
		74	76
		33	39
		50	53
		38	45
		61	36
		21	62
		41	43
		26	51
		80	32
		42	42
		29	54
		33	52
		35	37
		45	38
		49	32
		39	45
		34	60
		26	46
		25	40
		33	36
		35	47
		35	29
		28	43
		30	37
		29	38
		61	45
		32	50
		33	48
		45	60
	Mean	35.8780487805	44.1219512195
	Median	33	42
	Var	121.9851279001	79.9363474123
	Max	80	76
	Min	21	29
	Range	59	47
Sheet1
	
Actresses
Actors
Sheet2
	
		Actresses	Actors
		22	44
		37	41					Box plot showing actors and actresses
		28	62
		63	52
		32	41
		26	34
		31	34
		27	52
		27	41
		28	37
		30	38
		26	34
		29	32
		24	40
		38	43
		25	56
		29	41
		41	39
		30	49
		35	57
		35	41
		33	38
		29	42
		38	52
		54	51
		24	35
		25	30
		46	39
		41	41
		28	44
		40	49
		39	35
		29	47
		27	31
		31	47
		38	37
		29	57
		25	42
		35	45
		60	42					Actors box plot
		43	44
		35	62
		34	43
		34	42
		27	48
		37	49
		42	56
		41	38
		36	60
		32	30
		41	40
		33	42
		31	36
		74	76
		33	39
		50	53
		38	45
		61	36
		21	62
		41	43
		26	51
		80	32
		42	42
		29	54
		33	52
		35	37
		45	38
		49	32
		39	45
		34	60
		26	46
		25	40
		33	36
		35	47
		35	29
		28	43
		30	37
		29	38
		61	45
		32	50
		33	48
		45	60
Sheet3

Good evening,Please see Excel Formulas and Charts assignment: Excel Formulas and Charts: Assignment Requirements – turn in an Excel file with a different tab for each part below: In an Excel file do...

Answer To: Good evening,Please see Excel Formulas and Charts assignment: Excel Formulas and Charts: Assignment...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment