Question

A small school has only two 4^th grade classes and two 5^th grade classes. Each year, students at the school take the Nebraska Test of Basic Skills (NTBS) in math and Language Arts. The Excel file, 745 Project Data, contains all of the scores for a certain class tracked over their 4^th and 5^th grade years.

Create a frequency distribution and cumulative frequency distribution of the 4^th Grade Math test scores for all of the students. Use 5 classes.

Create a histogram, frequency polygon, and ogive for the 4^th Grade Math test scores for all of the students.

Create a box-and-whiskers plot for the 5^th Grade LA test scores for all of the students.

Determine whether or not students in the two 4^th grade classes have the same average scores in math, and whether or not students in the two 4^th grade classes have the same average score in language arts. For both tests, use ? = 0.05.

It has been observed that Crenshaw’s students don’t seem to do in well in math. To investigate that, for the 19 students who had Crenshaw in 5^th grade, determine whether or not their math scores decreased from 4^th to 5^th grades. Use ? = 0.05. Do the same for the 17 students who had Davis in 5^th grade. What can you conclude from these tests?

On the other hand, Crenshaw’s students seem to excel in language arts. To investigate that, for the 19 students who had Crenshaw in 5^th grade, determine whether or not their language arts scores increased from 4^th to 5^th grades. Use ? = 0.05. Do the same for the 17 students who had Davis in 5^th grade. What can you conclude from these tests?

On the basis of questions 4 through 6, what would you, as an administrator, recommend regarding Crenshaw and Davis?

Determine whether or not there is a relationship between the math scores and the LA scores in 4th grade, and if there is a relationship between the math scores and the LA scores in 5th grade. Use ? = 0.05.

Student	4th Grade      Teacher	4th Grade Math	4th Grade LA	5th Grade             Teacher	5th Grade         Math	5th Grade             LA
1	Anderson	580	620	Crenshaw	560	615
2	Anderson	520	600	Crenshaw	510	645
3	Anderson	595	570	Crenshaw	600	575
4	Anderson	720	650	Crenshaw	730	670
5	Anderson	570	620	Crenshaw	570	640
6	Anderson	660	750	Crenshaw	650	780
7	Anderson	545	480	Crenshaw	540	520
8	Anderson	500	550	Crenshaw	510	590
9	Anderson	680	640	Crenshaw	650	670
10	Anderson	580	630	Davis	600	630
11	Anderson	610	580	Davis	600	585
12	Anderson	780	720	Davis	780	700
13	Anderson	540	620	Davis	570	610
14	Anderson	480	630	Davis	520	650
15	Anderson	530	580	Davis	560	580
16	Anderson	640	625	Davis	630	620
17	Anderson	600	680	Davis	620	630
18	Baker	610	670	Crenshaw	600	700
19	Baker	510	580	Crenshaw	500	610
20	Baker	570	570	Crenshaw	550	630
21	Baker	525	600	Crenshaw	550	590
22	Baker	570	610	Crenshaw	557	650
23	Baker	590	600	Crenshaw	570	670
24	Baker	560	700	Crenshaw	525	690
25	Baker	530	580	Crenshaw	520	630
26	Baker	690	740	Crenshaw	680	780
27	Baker	600	610	Crenshaw	600	640
28	Baker	520	480	Davis	550	500
29	Baker	575	610	Davis	570	610
30	Baker	590	570	Davis	580	590
31	Baker	620	690	Davis	650	680
32	Baker	500	540	Davis	520	525
33	Baker	590	510	Davis	610	515
34	Baker	670	590	Davis	660	600
35	Baker	510	550	Davis	525	560
36	Baker	580	575	Davis	590	570

Answer 1

A small school has only two 4th grade classes and two 5th grade classes. Each year, students at the school take the Nebraska Test of Basic Skills (NTBS) in math and Language Arts. The Excel file, 745 Project Data, contains all of the scores for a certain class tracked over their 4th and 5th grade years.

Create a frequency distribution and cumulative frequency distribution of the 4th Grade Math test scores for all of the students. Use 5 classes.

Smallest score is 480 and largest score is 780.

Now we have to make classes and find corresponding frequency.

SO we make class of width 70.

So first class is 450-520, next one is 520-590 and so on.

Now we have to find frequency of each class.

Frequency is the number of observations fall in the corresponding class.

So the complete frequency distribution is,

class	frequency
450-520	5
520-590	15
590-660	10
660-730	5
730-800	1
total	36

Cumulative distribution is,

class	frequency	cumulative
450-520	5	5
520-590	15	20
590-660	10	30
660-730	5	35
730-800	1	36
total	36

Create a histogram, frequency polygon, and ogive for the 4th Grade Math test scores for all of the students.

We can draw histogram in excel.

steps :

ENTER data into excel sheet --> select class and frequency --> Insert --> Columns --> 2-D column --> select first option --> right click on bars --> format data series --> adjust gap width to 0 --> close

Frequency polygon :

Excel steps :

ENTER data into excel sheet --> Insert --> Line --> 2-D line --> ok

Ogive curve :

ENTER data into excel sheet --> Insert --> Scatter --> select second option --> ok

These are the three graphs.

Create a box-and-whiskers plot for the 5th Grade LA test scores for all of the students.

We can construct boxplot in MINITAB.

steps :

ENTER data into MINITAB sheet --> Graph --> Boxplot --> Simple --> ok --> Graph variable : select data column --> ok

Determine whether or not students in the two 4th grade classes have the same average scores in math, and whether or not students in the two 4th grade

Here we have to test the hypothesis that,

H0 : mu = 650 Vs H1 : mu not= 650

mu is population mean.

By assumption we take mu = 650

Here we have given sample data so we use one sample t-test.

We can do one sample t test in MINITAB.

steps :

ENTER data into MINITAB sheet --> Stat --> Basic statistics--> one sample t --> select data column --> Perform hypothesis test --> Hypothesized mean : 650 --> options --> Confidence level : 95.0 --> Alternative hypothesis : not= --> ok -> ok

One-Sample T: math

Test of ? = 650 vs ? 650

Variable N Mean StDev SE Mean 95% CI T P
math 36 584.4 66.6 11.1 (561.9, 607.0) -5.91 0.000

Test statistic = -5.91

P-value = 0.000

P-value < alpha

Reject H0 at 5% level of significance.

COnclusion :  students in the two 4th grade classes have not same average scores in math.

SImilarly we have to do for language arts.

One-Sample T: la

Test of ? = 650 vs ? 650

Variable N Mean StDev SE Mean 95% CI T P
la 36 608.9 63.6 10.6 (587.4, 630.4) -3.88 0.000

Here also p-value < alpha (0.05)

Reject H0 at 5% level of significance.

Conclusion :  students in the two 4th grade classes have not same average scores in language arts.