Five States Report

profileMonique5997
CopyofStatesReportAutoRecovered.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 up all the 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
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
South Carolina 20 21 25 25 26 30 31 34 41 47 52 56 62 63 67 69 75 76 84 91
Mean Step#1) add up all the Values
995
Step#2) I divide the total above by 20( since I have 20 data values) I have highlight them below
49.75
Median Step #1) I rank my 20 values from smallest to largest
20 21 25 25 26 30 31 34 41 47 52 56 62 63 67 69 75 76 84 91
Step#2) I find the two middle values since I have old number of data I have an even number of data( I have highlightrf them below) (
20 21 25 25 26 30 31 34 41 47 52 56 62 63 67 69 75 76 84 91
Step#3) Find the avaerage of these two numbers the average of these two numbers
25.5
Mode Step#1 I rank my 20 values from smallest to largest
20 21 25 25 26 30 31 34 41 47 52 56 62 63 67 69 75 76 84 91
The mode is the most commomly listed data value. Since multiple values are listed twice, but none is listed more than two times, I do not have a mode
Georgia 19 22 24 26 28 35 39 39 39 40 48 48 49 50 54 58 59 60 88
Mean Step#1) add up all the Values
825
Step#2 I divide the total above by 19( since I have 19 data values) I have highlight them below
43.42
Median Step#1) I ran 19 values from smallest to largest
19 22 24 26 28 35 39 39 39 40 48 48 49 50 54 58 59 60 88
Step#2) I find the two middle values since I have the two middle values values I have an odd number of data ( I have highlight them below
19 22 24 26 28 35 39 39 39 40 48 48 49 50 54 58 59 60 88
Step#3) Find the average of one number these two numbers
39.5
Mode step#1 I rank my 19 value from smallest to largest)
19 22 24 26 28 35 39 39 39 40 48 48 49 50 54 58 59 60 88
The Mode is the most commonly listed data value. Since multiple values are listed twice, but 39 and 48 is listed more than two times
Florida 39 52 54 60 60 62 63 63 63 64 64 65 66 66 70 71 74
Mean Step #1 I added up all the Values
1056
Step#2 I divided the total above by 17 since I have 17 data values( I have highlighted below)
62.11
Median I ran 17 values from smallest to largest
39 52 54 60 60 62 63 63 63 64 64 65 66 66 70 71 74
I find the two middle values I have I have even mumber of data( I have hight them below) lighted below
39 52 54 60 60 62 63 63 63 64 64 65 66 66 70 71 74
Find the average of these two numbers
63.5
Mode The Mode is the most commonly listed data value. Since multiple values are listed twice but 63 is listed more than two times
North Carolina
22 27 27 29 29 29 37 40 43 44 46 48 48 48 50 50 52 54 58 61
Mean
Step#1 Add up all the values
842
I divided the total by 20 since I have 20 data values ( I have highlightred below
42.35
Median I ran 20 values from smallest to largest
22 27 27 27 29 29 37 40 43 44 46 48 48 48 50 50 52 54 58 61
I find the two middle two value . I have even number of data
22 27 27 27 29 29 37 40 43 44 46 48 48 48 50 50 52 54 58 61
Find the avaerage if the two number
45
Mode The Mode is the most commonly listed data value. Since multiple values are listed twice but 27,29,48 is listed more than two times