Math 1070: Spreadsheet Project Statistical Analysis Report

This assignment analyzes a spreadsheet project likely from a Math 1070 course, focusing on statistical analysis and data interpretation. The project involves analyzing two datasets, presumably representing male and female body measurements. The analysis includes calculating descriptive statistics such as minimum, maximum, mean, and standard deviation. Outlier detection is performed, identifying a potential outlier in the female dataset. A t-test is conducted to compare the means of the two groups. Histograms are generated to visualize the distribution of the data for both males and females. The solution demonstrates the application of statistical concepts and the use of spreadsheet software for data analysis, including calculations, graphing, and interpretation of results. The document serves as a practical example of statistical analysis, offering insights into data characteristics, comparisons, and potential outliers, as well as providing a breakdown of the steps followed in the analysis.

s.no. male female
1 96.3 96.4 Particulars Male Female
2 96.7 96.7 Minimum Value 96.30 96.40
3 96.9 96.8 Maximum Value 99.50 100.80
4 97 97.2 Mean 98.10 98.39
5 97.1 97.2 Standard Deviation 0.70 0.74
6 97.1 97.4 3* Standard deviation 2.10 2.23
7 97.1 97.6 Lower limit for outlier 96.01 96.16
8 97.2 97.7 Upper limit for outlier 100.20 100.62
9 97.3 97.7
10 97.4 97.8 Outlier is present for female since 100.8 exceeds 100.62
11 97.4 97.8 Hence the 65th observation would be excluded.
12 97.4 97.8
13 97.4 97.9
14 97.5 97.9 t-Test: Two-Sample Assuming Equal Variances
15 97.5 97.9
16 97.6 98 male female
17 97.6 98 Mean 98.08 98.36
18 97.6 98 Variance 0.46 0.47
19 97.7 98 Observations 64 64
20 97.8 98 Pooled Variance 0.47
21 97.8 98.1 Hypothesized Mean Difference 0
22 97.8 98.2 df 126
23 97.8 98.2 t Stat -2.2649
24 97.9 98.2 P(T<=t) one-tail 0.0126
25 97.9 98.2 t Critical one-tail 1.6570
TESTING FOR OUTLIERS
25 97.9 98.2 t Critical one-tail 1.6570
26 98 98.2 P(T<=t) two-tail 0.0252
27 98 98.2 t Critical two-tail 1.9790
28 98 98.3
29 98 98.3
30 98 98.3
31 98 98.4
32 98.1 98.4
33 98.1 98.4
34 98.2 98.4
35 98.2 98.4
36 98.2 98.5
37 98.2 98.6
38 98.3 98.6
39 98.3 98.6
40 98.4 98.6
41 98.4 98.7
42 98.4 98.7
43 98.4 98.7
44 98.5 98.7
45 98.5 98.7

46 98.6 98.7
47 98.6 98.8
48 98.6 98.8
49 98.6 98.8
50 98.6 98.8
51 98.6 98.8
52 98.7 98.8
53 98.7 98.8
54 98.8 98.9
55 98.8 99
56 98.8 99
57 98.9 99.1
58 99 99.1
59 99 99.2
60 99 99.2
61 99.1 99.3
62 99.2 99.4
63 99.3 99.9
64 99.4 100
65 99.5 100.8

Row Labels Count of male
96.3-97.3 8
97.3-98.3 29
98.3-99.3 25
99.3-100.3 3
Grand Total 65
0
5
10
15
20
25
30
35
96.3-97.3 97.3-98.3 98.3-99.3 99.3-100.3
Histogram
Body Measurements for Male

Row Labels Count of female
96.4-97.4 5
97.4-98.4 25
98.4-99.4 31
99.4-100.4 3
100.4-101.4 1
Grand Total 65
0
5
10
15
20
25
30
35
96.4-97.4 97.4-98.4 98.4-99.4 99.4-100.4 100.4-101.4
Histogram
Body Measuremets for Female