Statistics

After downloading the excel data generator, please take a screen shot like below then attach it on the first page of the project.

Figure 1Excel data generator

Figure 2

If you do not attach, you will lose 10% of the grade.

After downloading the excel data generator, please take a screen shot like below then attach it on the first page of the project.

Sample Cover page

MA-135(Section #):

Title

Figure 3Picture

Student’s name:

Date: …………….

Professor’s name:

Sample project of MA-135

Write down the name of the project here.

Add your own introduction here (one paragraph)

The data collected from the 12 men & the calculations asking in the project are shown in the table below:

Male	Time in Second(X)		Number of Days Workout	Favorite Workout
M1	Use the number from the excel data generator	Square the x value from left column for each row below	Use the number from the excel data generator	Use the list from the excel data generator
M2
M3
M4
M5
M6
M7
M8
M9
M10
M11
M12

n = 12 Median= Mode=

Mean (M) = =

SS =

The standard deviation: S = = =

The Standard error of the mean: = = =

Level α = 0.10

df = n-1 = 12-1= 11

t Value (From the chart) = ±1.796

90% confidence interval for the men = M ± CV X

The data collected from the 8 women & the calculations asking in the project are shown in the table below:

Female	Time in second(X)		Number of Days Workout	Favorite Workout
FM1	Use the number from the excel data generator	Square the x value from left column for each row below	Use the number from the excel data generator	Use the list from the excel data generator
FM2
FM3
FM4
FM5
FM6
FM7
FM8

n = 8 ∑X = Med= Mode

Mean: M = =

SS =

The standard deviation: S = = =

The standard error of the mean: = = =

Level α = 1-0.90 = 0.10.

df = n-1 = 8-1 =7

t value (From the chart) = 1.895

90% confidence interval for the women= M ±CV (t-value) X

Hypothesis test:

Male Female

= 12 = 8

= use mean from male group = use mean from female group

= use from male group = use from female group

df = + - 2

= 12 + 8 -2

df = 18

Level = 0.05.

1. The null hypothesis ( ) : - = 0

1. The alternative hypothesis ( ) : ≠ 0

1. The critical value : t = ± 2.101

1. The test statistics : Detail calculations

Pooled variance: = = = = 8.23 This is just a sample!

Estimated standard error: = =

= = = 1.31(you will have different answer)

The t statistics: t = = = = -2.48 (you will have different answer)

The test statistics: = -2.48 (you will have different answer)

1. Decision:

Figure 4 Normal curve

Make sure you level the CV and don’t forget to shade the area of the region!

1. Conclusion about the claim: At _____% significant level, the data_______ provide sufficient evidence to ………………………………………………………………..

5