We are only concerned with columns A-D, four variables of: State Name (Column A), Number of Unemployment insurance claims (Column B), Change in the number of claims from the prior week (Column C), and Change in number of claims from this week in 2019 (Column D). The other columns can be ignored. Complete each of these tasks directly in your Excel Spreadsheet. -Produce a frequency table and either a histogram or stem and leaf plot of the current number of claims and compare to 2019 for each state as a first look. Interpret the results. -Compute measures of center and spread for each variable and interpret. -Produce a 5 number summary of each variable and interpret. Finally, be sure to draw some conclusions on your data in paragraph form. You can either use MS Word or just insert a text box in a new worksheet in Excel. Be sure to insert at least one graph or chart you create and discuss into the MS Word document
We are only concerned with columns A-D, four variables of: State Name (Column A), Number of Unemployment insurance claims (Column B), Change in the number of claims from the prior week (Column C), and Change in number of claims from this week in 2019 (Column D). The other columns can be ignored. Complete each of these tasks directly in your Excel Spreadsheet. -Produce a frequency table and either a histogram or stem and leaf plot of the current number of claims and compare to 2019 for each state as a first look. Interpret the results. -Compute measures of center and spread for each variable and interpret. -Produce a 5 number summary of each variable and interpret. Finally, be sure to draw some conclusions on your data in paragraph form. You can either use MS Word or just insert a text box in a new worksheet in Excel. Be sure to insert at least one graph or chart you create and discuss into the MS Word document
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
