MATH 111 ASSIGNMENT 2

profilepie18k
AUO_MAT111_M2A2_UsingDescriptiveStatistics11.xls
Home>Mathematics homework help>Statistics homework help>MATH 111 ASSIGNMENT 2

Samples

Brillton EX Gas Mileage Sample Data
Sample A Sample B Sample C Sample D Sample E Sample F Sample G Sample H Sample I
City Hwy City Hwy City Hwy City Hwy City Hwy City Hwy City Hwy City Hwy City Hwy
42 56 57 25 37 41 35 44 23 38 34 54 12 14 34 16 42 47
33 40 18 26 34 49 42 43 13 28 45 22 44 50 34 32 33 30
31 31 21 41 44 54 39 15 18 35 40 21 14 56 26 37 14 22
12 18 55 44 13 52 53 56 29 53 50 26 40 56 22 15 33 54
31 11 21 12 12 32 31 32 14 49 31 31 16 26 33 50 25 26
20 54 37 32 22 17 50 47 30 26 33 40 18 26 34 49 42 43 28 45
34 54 12 14 34 16 42 47 25 37 41 35 44 23 38 57 25 37
45 22 44 50 34 32 33 30 26 34 49 42 43 13 28 18 26 34
40 21 14 56 26 37 14 22 41 44 54 39 15 18 35 21 41 44
50 26 40 56 22 15 33 54 44 13 52 53 56 29 53 55 44 13
31 31 16 26 33 50 25 26 12 12 32 31 32 14 49 21 12 12
33 40 18 26 34 49 42 43 32 22 17 50 47 30 26 37 32 22
Copy both City and Hwy data columns from under the sample heading that you want to analyze. You will paste this data into the next tab labeled "Descriptive Statistics."

Descriptive Statistics

Sample Data MPG Descriptive Statistics
City Hwy City Hwy
Mean 0 0
Median 0 0
Mode 0 0
Standard Deviation 0 0
Variance 0 0
Paste your data here. Click on box A3, then click the Paste icon on the top left of the page.
After you have pasted your data, the Excel spreadsheet will perform the calculations and populate this descriptive statistics table.

Population

All Data
City Hwy MPG Descriptive Statistics - Population
42 56 City Hwy
33 40 Mean 33.61 33.96
31 31 Median 34 32
12 18 Mode 33 26
31 11 Standard Deviation 12.68 13.97
20 54 Variance 160.85 195.02
34 54
45 22
40 21
50 26
31 31
33 40
57 25
18 26
21 41
55 44
21 12
37 32
12 14
44 50
14 56
40 56
16 26
18 26
37 41
34 49
44 54
13 52
12 32
22 17
34 16
34 32
26 37
22 15
33 50
34 49
35 44
42 43
39 15
53 56
31 32
50 47
42 47
33 30
14 22
33 54
25 26
42 43
23 38
13 28
18 35
29 53
14 49
30 26
25 37
26 34
41 44
44 13
12 12
32 22
34 54
45 22
40 21
50 26
31 31
33 40
41 35
49 42
54 39
52 53
32 31
17 50
12 14
44 50
14 56
40 56
16 26
18 26
44 23
43 13
15 18
56 29
32 14
47 30
34 16
34 32
26 37
22 15
33 50
34 49
38 57
28 18
35 21
53 55
49 21
26 37
42 47
33 30
14 22
33 54
25 26
42 43
25 37
26 34
41 44
44 13
12 12
32 22
19 40
28 22
38 54
55 35
26 30
55 25
34 52
43 28
46 45
52 54
41 15
52 19
40 48
18 14
56 19
40 27
35 14
53 19
35 50
55 14
38 38
50 27
46 18
23 29
35 21
24 30
48 13
55 41
15 26
33 33
15 51
37 39
12 53
54 26
55 15
23 26
39 51
40 24
39 44
15 51
49 56
32 52
21 15
30 56
37 32
13 47
52 33
21 32
16 50
36 15
This table is the population data for all of the Brillton EX models that were tested by the manufacturer.