Question

Use data from Excel to complete problems 3.1 and 3.2. When you open the file look at the tabs on the bottom left. You will use the data from the “Class_LabScores” tab to answer these questions.

Frequency distribution tables for Dr. Wallace's three statistics courses
X = quiz scores
	Class 1			Class 2			Class 3
	X	f		X	f		X	f
	0	3		0	0		0	3
	1	0		1	0		1	0
	2	0		2	0		2	1
	3	2		3	3		3	0
	4	3		4	2		4	0
	5	6		5	1		5	2
	6	4		6	2		6	3
	7	2		7	0		7	1
	8	3		8	4		8	1
	9	2		9	2		9	0
	10	1		10	3		10	0
	11	4		11	4		11	2
	12	3		12	3		12	4
	13	8		13	6		13	6

3.1. Dr. Wallace teaches three statistics labs at three different times of day (1 - morning, 2 - noon, 3 - night). She is curious to find out whether or not time of day is related to student scores on the lab assignments. Frequency distribution tables for each of her three lab classes appear on the “Class_LabScores” tab in the Excel file. Please calculate the following:

Mean for Morning Class 1:

Mean for Noon Class 2:

Mean for Night Class 3:

3.2 Dr. Wallace is preparing a summary of her teaching experience in the statistics lab classes. She only wants to use one number to represent student performance in those classes, so she’ll need to calculate one mean. In addition, she wants to be fair and make sure that every student’s lab score contributes equally to the overall mean. In order to do this, she needs to calculate the weighted mean. Please calculate the following and show work:

Weighted mean for her statistics classes:

Answer 1

3.1)

Mean formula

where

For class 1 ,class 2 and class 3

Now for class 1

So mean for class 1

----------------------------------------------------------------------

For class 2

Mean for class 2

--------------------------------------------------------------------------

for class 3

Mean for class 3

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

3.2) weighted mean

For class1,

weighted mean =

For class 2

weighted mean =

For class 3

weighted mean

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

PLEASE UPVOTE IF YOU LIKE MY ANSWER.

THANK YOU.