Question:

1. Explain what type of analysis and hypothesis test was conducted on the data collected.
2. Summarize the survey results based on the results of the data you analyzed.
3. Include the Excel analysis as part of the document.

My work from my data:

What grade did you first start getting bullied?

Grade # of Students

1 1

2 1

3 8

4 10

5 6

6 2

7 2

8 0

Total 30

My analysis:

X F XF F(x-x)

1 1 1 9.61

2 1 2 4.41

3 8 24 9.68

4 10 40 0.1

5 6 30 4.86

6 2 12 7.22

7 2 14 16.82

8 0 0 0

Sum 30 123 52.7

Population Mean:

x=grade f=Number of student

x = 1/n*x*f = 123/30=4.1

Standard Deviation:

s²=1/(n-1)* *f(x- x) =52.7/29=1.8172

s=1.8172= 1.3481

CI =x+t*s/n

d.f= n-1=29

Confidence Interval 95%

t= 2.045

CI =4.1 + 2.045*1.3481/sqrt(30)

( 3.5967, 4.6033)

I am 95% confident that population mean grade score is within this interval.

Confidence Interval 90%

t=1.699

CI =4.1 + 1.699*1.3481/sqrt(30)

( 3.6818, 4.5182)

I am 90% confident that population mean grade score is within this interval.

Confidence Interval 98%

t= 2.462

CI =4.1 + 2.462*1.3481/sqrt(30

(3.4940, 4.7060)

I am 98% confident that population mean grade score is within this interval.