1. Click on the following link: # MTH 243 W2022 WrittenHW2 Min WageData or copy and paste the following link in your browser: https://docs.google.com/spreadsheets/d/1IUAiWhGfznvbQcjUbf8hqElzde9-USIBTrQ5f TJyeT8/edit?usp=sharing 2. Click on File - Make a Copy. Rename the file so it includes your first and last name, then click OK. 3. The spreadsheet includes minimum wage data for all 50 states in the U.S., plus Washington D.C. First you will create a histogram to show the shape of the distribution of the minimum wage variable. a. Highlight the entire 2022 Minimum Wage column (cells B1-B52). b. Click on Insert - Chart. The Chart Editor will appear on the right side of your screen. C. Under Chart Type, change the selection to Histogram Chart (you will need to scroll down to the second option in the "other" section). d. Next click Customise, then click Chart & axis titles. Change the chart title to "2022 Minimum Wage by State" e. Switch the dropdown menu from Chart title to Horizontal axis title. Change the horizontal axis title to "2022 minimum wage ($)" f. Lastly, change the vertical axis title to "Number of states" 4. Next we compute some summary statistics. You will enter your formulas in the light purple cells, then click enter to see the cell autofill with the desired calculation. a. To find the mean: =average(B2:B52) b. To find the population standard deviation: =stdevp(B2:B52) c. To find the minimum value: =min(B2:B52) d. To find quartile 1: =quartile(B2:B52,1) e. To find the median: =median(B2:B52) f. To find quartile 3: =quartile(B2:B52,3) g. To find the maximum value: =max(B2:B52) (Note: instead of typing the range B2:B52, you can also highlight the desired range of values.)5. Click on the bright yellow cell to open the note stored there. I recommend clicking and dragging the bottom right corner to enlarge the note if needed. Answer the questions by typing your answers directly into the note. When you're finished, your screen should look something like this. (The circled cells should contain the numbers computed from the formulas in step 4.) State 2022 Minimum Wage Notes Summary Statistics CLICK YELLOW CELL Alabama $7.25 Mean Alaska $10.34 Standard deviation Arizona $12.80 Arkansas $11.00 Minimum California $15.00 Quartile 1 Colorado $12.56 Median Connecticut $14.00 Effective 7/1/2022 Quartile 3 Delaware $10.50 Maximum Washington D.C. $15.20 Florida $11.00 Effective 9/30/2022 Georgia $5.15 Employers subject to the Fair Labor Standards Act must pay the $7.25 Federal minimum wage Hawaii $10.10 Idaho $7.25 2022 Minimum Wage by State Illinois $12.00 Indiana $7.25 lowa $7.25 15 Kansas $7.25 Kentucky $7.25 Louisiana $7.25 Federal, no state minimum 10 Number of state Maine $12.75 Maryland $12.50 Massachusetts $14.25 Michigan $9.87 Minnesota $10.33 5.00 6.50 8.00 9.50 11.00 12.50 14.00 15.50 Mississippi $7.25 Federal, no state minimum 2022 minimum wage (5) 6. IMPORTANT SO I HAVE ACCESS TO YOUR SPREADSHEET: Click on the green Share button in the upper right corner and change the settings as shown below. Then click Copy Link. https://docs.google.com/spreadsheets/d/1hsCwH3yfH5AQKoqM1bsiTGN6... Copy link Anyone with the link Commenter Anyone on the internet with this link can comment Send feedback to Google Done 7. Return to our D2L page - Assignments - Written Homework 2. You may now paste your link in the comments section of the submission box. Click Submit and you're done