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=gradef=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.