[SOC 202 Assignment 1 due before 11:30pm Tuesday July 6, 2021] Page 1 of 2 Introductory Social Statistics (SOC202) Assignment 1 (Total Score = 50) Due before 11:30pm Tuesday July 6, 2021 IMPORTANT...

2 answer below »
see attatchment


[SOC 202 Assignment 1 due before 11:30pm Tuesday July 6, 2021] Page 1 of 2 Introductory Social Statistics (SOC202) Assignment 1 (Total Score = 50) Due before 11:30pm Tuesday July 6, 2021 IMPORTANT INSTRUCTIONS: • Please submit in any of these format, e.g., MS Excel, MS Word, or pdf. Do NOT upload “pages” (mac users) document as it is not supported by D2L • Please see an example attached herewith and posted on D2L to have an idea to how to make a frequency distribution table • To receive full points for each problem you must show statistical formula used, process of computation, and provide meaningful interpretations of results in full sentences • Tables and Charts have to be labeled with appropriate title and source information or points deducted • Table columns and Chart legends should be meaningfully labeled both in words and statistical symbols or points will be taken off • Calculations could be rounded up to nearest two decimal points • Do the assignment on your own. Do NOT copy from or use anybody/anywhere in class or outside. Questions Go to Minnesota Department of Health Website Situation Update for COVID-19 (https://www.health.state.mn.us/diseases/coronavirus/situation.html#map1). In the middle of the webpage, find “Residence” and “Cases by County of Residence” section. Below the map click on the “County of residence data table” to find a data on COVID-19 deaths in each of the 87 counties in Minnesota. Use the data in column “Total deaths” as per “County” to answer to following questions: 1) Draw a frequency distribution table of ungrouped data and provide necessary columns and rows of statistical information (i.e., frequencies (f), relative frequencies and percent [(f/N)%], cumulative frequencies and percent [(Cf/N)%], total frequencies (N), and total deaths [∑X(f)]. Be sure to provide table title as Table 1 and meaningfully label all the columns including statistical symbols. [3 points] A. The counties with up to how many cases are within the 1st Quarter, half or 2nd Quarter, and 3rd Quarter of the total deaths? [3 point] B. Calculate the Average or Mean from the raw data and from the frequency distribution. Report your result in a full sentence. [3 point] 2) Draw a grouped frequency distribution table providing necessary statistical information [i.e., class intervals (i), mid-points (Mi), frequencies (f), relative frequencies and percent [(f/N)%], cumulative frequencies and percent [(Cf/N)%], total frequencies (N), and total deaths [∑Mi(f)]. Be sure to provide table title as Table 2 and meaningfully label all the columns including statistical symbols. [3 points] A. Draw a histogram chart/graph from the grouped frequency table to visually show the percent of COVID-19 death in the MN Counties. [3 points] B. Calculate the Average or Mean from the grouped frequency distribution. Report your result in a full sentence. [3 point] https://www.health.state.mn.us/diseases/coronavirus/situation.html#map1 [SOC 202 Assignment 1 due before 11:30pm Tuesday July 6, 2021] Page 2 of 2 3) Calculate the standard deviation using mean deviation method [see example in textbook (pg. 60-61): Step-by-Step Illustration: Standard Deviation]. Show your detailed work including all the steps, table, and formulas and process of calculations. Interpret the standard deviation value you found in full sentence. (Total = 8 points) 4) Calculate variance and standard deviation using raw-score method [see example in textbook (pg. 61-62): Step-by-Step Illustration: Variance and Standard Deviation Using Raw Scores]. Show your detailed work including all the steps, table, and formulas and process of calculations. Interpret the standard deviation value you found in full sentence. (Total = 8 points) 5) Calculate variance and standard deviation using ungrouped frequency distribution [see example in textbook (pg. 62-63): Step-by-Step Illustration: Variance and Standard Deviation of a Simple Frequency Distribution]. Show your detailed work including all the steps, table, and formulas and process of calculations. Interpret the standard deviation value you found in full sentence. (Total = 8 points) 6) Calculate variance and standard deviation using grouped frequency distribution [See example in your textbook (pg. 67-68) 4.10: Obtaining the Mean and Standard Deviation from a Grouped Frequency Distribution]. Show your detailed work including all the steps, table, and formulas and process of calculations. Interpret the standard deviation value you found in full sentence. (Total = 8 points) Go to Minnesota Department of Health Website Situation Update for COVID-19
assignment1soc202sum2021-ua1vhjty.pdf
Answered 16 days AfterJul 02, 2021

Answer To: [SOC 202 Assignment 1 due before 11:30pm Tuesday July 6, 2021] Page 1 of 2 Introductory Social...

Mohd answered on Jul 19 2021
134 Votes
Q2&6
    County    Total confirmed cases    Total probable cases    Total cases    Total deaths
    Aitkin    1,342    47    1,389    37    Bin_Range    Bin    Bin    Frequency    Cumulative %    frequency %    cummalative    Midpoint(X)    Mean(Xbar)    X-Xbar    (X-Xbar)^2    F*(X-Xbar)^2
    Anoka    37,696    5,360    43,056    465    0-100    100    100    76    87.36%    87.36%    76.00    50    87.76    -37.76    1425.7134    108354.221165279
    Becker    3,580    305    3,885    56    101-200    200    200    4    91.95%    4.60%    80.00    150    87.76    62.24    3873.9893    15495.9571938169
    Beltrami    3,487    602    4,089    63    201-300    300    300    2    94.25%    2.30%    82.00    250    87.76    162.24    26322.2652    52644.5303210464
    Benton    5,425    418    5,843    98    301-400    400    400    1    95.40%    1.15%    83.00    350    87.76    262.24    68770.5410    68770.5410225922
    Big Stone    573    34    607    4    401-500    500    500    2    97.70%    2.30%    85.00    450    87.76    362.24    131218.8169    262437.633769322
    Blue Earth    7,507    163    7,670    44    501-600    600    600    0    97.70%    0.00%    85.00    550    87.76    462.24    213667.0927    0
    Brown    3,013    73    3,086    40    601-700    700    700    0    97.70%    0.00%    85.00    650    87.76    562.24    316115.3686    0
    Carlton    2,864    692    3,556    57    701-800    800    800    0    97.70%    0.00%    85.00    750    87.76    662.24    438563.6445    0
    Carver    9,458    1,250    10,708    49    801-900    900    900    0    97.70%    0.00%    85.00    850    87.76    762.24    581011.9203    0
    Cass    2,685    191    2,876    33    901-1000    1000    1,000    1    98.85%    1.15%    86.00    950    87.76    862.24    743460.1962    743460.196195006
    Chippewa    1,483    57    1,540    38    1001-1100    1100    1,100    0    98.85%    0.00%    86.00    1050    87.76    962.24    925908.4721    0
    Chisago    5,714    532    6,246    53    1101-1200    1200    1,200    0    98.85%    0.00%    86.00    1150    87.76    1062.24    1128356.7479    0
    Clay    7,701    584    8,285    92    1201-1300    1300    1,300    0    98.85%    0.00%    86.00    1250    87.76    1162.24    1350805.0238    0
    Clearwater    737    154    891    17    1301-1400    1400    1,400    0    98.85%    0.00%    86.00    1350    87.76    1262.24    1593253.2996    0
    Cook    170    3    173    0    1401-1500    1500    1,500    0    98.85%    0.00%    86.00    1450    87.76    1362.24    1855701.5755    0
    Cottonwood    1,474    202    1,676    24    1501-1600    1600    1,600    0    98.85%    0.00%    86.00    1550    87.76    1462.24    2138149.8514    0
    Crow Wing    6,436    414    6,850    98    1601-1700    1700    1,700    0    98.85%    0.00%    86.00    1650    87.76    1562.24    2440598.1272    0
    Dakota    42,598    4,476    47,074    475    1701-1800    1800    1,800    1    100.00%    1.15%    87.00    1750    87.76    1662.24    2763046.4031    2763046.40309156
    Dodge    1,850    32    1,882    3            More    0    100.00%
    Douglas    4,359    409    4,768    81                                            StandardDeviation    216.0482687982
    Faribault    1,539    26    1,565    19                                            Variance    46676.8544506816
    Fillmore    1,566    20    1,586    10
    Freeborn    3,443    52    3,495    34
    Goodhue    4,710    138    4,848    74
    Grant    573    21    594    8
    Hennepin    116,989    8,773    125,762    1,794
    Houston    1,684    67    1,751    16
    Hubbard    1,792    182    1,974    41
    Isanti    3,959    473    4,432    65
    Itasca    4,507    113    4,620    67
    Jackson    983    247    1,230    12
    Kanabec    1,413    60    1,473    28
    Kandiyohi    6,592    102    6,694    85
    Kittson    439    51    490    22
    Koochiching    908    55    963    19
    Lac qui Parle    688    73    761    22
    Lake    693    142    835    20
    Lake of the Woods    327    19    346    4
    Le Sueur    2,872    117    2,989    27
    Lincoln    563    21    584    3
    Lyon    3,470    179    3,649    54
    Mahnomen    546    20    566    9
    Marshall    828    60    888    17
    Martin    2,273    88    2,361    33
    McLeod    4,233    98    4,331    61
    Meeker    2,600    46    2,646    44
    Mille Lacs    2,956    178    3,134    55
    Morrison    4,033    230    4,263    62
    Mower    4,621    134    4,755    33
    Murray    882    190    1,072    10
    Nicollet    3,219    109    3,328    45
    Nobles    3,898    191    4,089    50
    Norman    510    39    549    9
    Olmsted    13,359    112    13,471    102
    Otter Tail    5,459    426    5,885    87
    Pennington    1,202    336    1,538    20
    Pine    3,087    279    3,366    23
    Pipestone    1,111    58    1,169    26
    Polk    3,544    358    3,902    72
    Pope    1,087    45    1,132    6
    Ramsey    49,689    3,108    52,797    910
    Red Lake    328    75    403    7
    Redwood    1,698    72    1,770    41
    Renville    1,758    69    1,827    46
    Rice    7,986    252    8,238    111
    Rock    1,128    160    1,288    19
    Roseau    1,982    133    2,115    21
    Scott    15,677    1,931    17,608    139
    Sherburne    10,805    1,277    12,082    95
    Sibley    1,379    92    1,471    10
    St. Louis    16,843    1,356    18,199    318
    Stearns    21,486    1,131    22,617    227
    Steele    3,900    102    4,002    19
    Stevens    890    36    926    11
    Swift    1,044    28    1,072    18
    Todd    2,814    58    2,872    33
    Traverse    269    110    379    5
    Wabasha    2,064    17    2,081    3
    Wadena    1,563    81    1,644    23
    Waseca    2,351    46    2,397    23
    Washington    25,668    1,905    27,573    296
    Watonwan    1,339    19    1,358    9
    Wilkin    725    112    837    13
    Winona    4,562    67    4,629    52
    Wright    14,337    2,131    16,468    151
    Yellow Medicine    1,023    130    1,153    20
    Unknown/missing    449    33    482    0
We have found that Standard Deviation and variance from grouped frequency distribution is is 216.04 and 46676.85 respectively.
dd
    County    Total confirmed cases    Total probable cases    Total cases    Total deaths
    Aitkin    1,342    47    1,389    37
    Anoka    37,696    5,360    43,056    465
    Becker    3,580    305    3,885    56
    Beltrami    3,487    602    4,089    63
    Benton    5,425    418    5,843    98
    Big Stone    573    34    607    4
    Blue Earth    7,507    163    7,670    44
    Brown    3,013    73    3,086    40
    Carlton    2,864    692    3,556    57
    Carver    9,458    1,250    10,708    49
    Cass    2,685    191    2,876    33
    Chippewa    1,483    57    1,540    38
    Chisago    5,714    532    6,246    53
    Clay    7,701    584    8,285    92
    Clearwater    737    154    891    17
    Cook    170    3    173    0
    Cottonwood    1,474    202    1,676    24
    Crow Wing    6,436    414    6,850    98
    Dakota    42,598    4,476    47,074    475    Bin_Range    Bin    Bin    Frequency    Cumulative %    Cumulative    Relative    Cumulative Relative(    [(f/N)%],    Mid...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?