Five States Report

profileMonique5997
Week6-CopyofStatesReport1.xlsx
Home>Mathematics homework help>Statistics homework help>Five States Report

Sheet1

Data Type ANNUAL INCOME (in thousands)
Alabama 37 35 32 34 40 46 25 32 42 33 46 35 54 24 22 54 50 53 25 42
Mean Step #1) I add up all these values
761
Step #2) I divide the total above by 20 (since I have 20 data values)
38.05
Median step #1) I rank my 20 values from smallest to largest
22 24 25 25 32 32 33 34 35 35 37 40 42 42 46 46 50 53 54 54
step #2) I find the two middle values since I have an even number of data (I have highlighted them below)
22 24 25 25 32 32 33 34 35 35 37 40 42 42 46 46 50 53 54 54
step #3) find the average of these two numbers
36
Mode step #1) I rank my 20 values from smallest to largest
22 24 25 25 32 32 33 34 35 35 37 40 42 42 46 46 50 53 54 54
Step#2)The mode is the most commonly listed data value. Since multiple values are listed twice, but none is listed more than two times, I do not have a mode.
No mode
Georgia 50 28 49 48 39 39 39 26 22 35 19 48 58 60 88 54 59 59 24 40
Mean Step #1) I add up all these values
884
step #2) I divide the total above by 20 (since I have 20 data values)
44.2
Median step #1) I rank my 20 values from smallest to largest
19 22 24 26 28 35 39 39 39 40 48 48 49 50 54 58 59 59 60 88
step #2) I find the two middle values since I have an even number of data (I have highlighted them below)
19 22 24 26 28 35 39 39 39 40 48 48 49 50 54 58 59 59 60 88
step #3) find the average of these two numbers
44
Mode step #1) I rank my 20 values from smallest to largest
19 22 24 26 28 35 39 39 39 40 48 48 49 50 54 58 59 59 60 88
step#2) The mode is the most commonly listed data value. Since multiple values are listed twice.
39
New York 29 88 70 65 55 30 29 20 49 33 84 39 55 68 78 59 88 55 52 51
Mean Step #1) I add up all these values
939
step #2) I divide the total above by 20 (since I have 20 data values)
46.95
Median step #1) I rank my 20 values from smallest to largest
20 29 29 30 33 39 49 51 52 55 55 55 59 65 68 70 78 84 88 88
step #2) I find the two middle values since I have an even number of data (I have highlighted them below)
20 29 29 30 33 39 49 51 52 55 55 55 59 65 68 70 78 84 88 88
step #3) find the average of these two numbers
55
Mode step #1) I rank my 20 values from smallest to largest
20 29 29 30 33 39 49 51 52 55 55 55 59 65 68 70 78 84 88 88
step#2) The mode is the most commonly listed data value. Since multiple values are listed twice.
N. Carolina 48 27 40 54 46 48 27 29 50 52 50 29 58 22 43 37 44 48 29 61
Mean Step #1) I add up all these values
842
step #2) I divide the total above by 20 (since I have 20 data values)
42.1
Median step #1) I rank my 20 values from smallest to largest
22 27 27 29 29 29 37 40 43 44 46 48 48 48 50 50 52 54 58 61
Step#2) I find the two middle values since I have an even number of data (I have highlighted them below)
22 27 27 29 29 29 37 40 43 44 46 48 48 48 50 50 52 54 58 61
step #3) find the average of these two numbers
45
Mode step #1) I rank my 20 values from smallest to largest
22 27 27 29 29 29 37 40 43 44 46 48 48 48 50 50 52 54 58 61
Step#20)The mode is the most commonly listed data value. Since multiple values are listed twice.
29 48
Hawaii 44 50 60 63 69 24 70 28 63 50 70 60 54 64 65 62 50 63 64 63
Mean Step #1) I add up all these values
1,136
Step #2) I divide the total above by 20 (since I have 20 data values)
56.8
Median step #1) I rank my 20 values from smallest to largest
24 28 44 50 50 50 54 60 60 62 63 63 63 63 64 64 65 69 70 70
step #2) I find the two middle values since I have an even number of data (I have highlighted them below)
24 28 44 50 50 50 54 60 60 62 63 63 63 63 64 64 65 69 70 70
step #3) find the average of these two numbers
62.5
Mode step #1) I rank my 20 values from smallest to largest
24 28 44 50 50 50 54 60 60 62 63 63 63 64 64 65 69 70 70
step#2) The mode is the most commonly listed data value. Since multiple values are listed twice.
63