Instructions: Work problems on a separate sheet of paper and attach work to this page. You shouldshow all work. Questions with compact answers can be recordeddirectly on this page. Graphs and longer answers that won’t fit here, indicate which page of the workthe answer can be found on and be sure to clearly indicate it on the attached pages. You may use Excelto complete the problems, but then submit Excel files online.1. A newspaper article on drunk driving cited data on traffic deaths in Rhode Island: “Forty-twopercent of all fatalities occurred on Friday, Saturday and Sunday, apparently because ofincreased drinking on the weekends.” What percent of the week do Friday, Saturday andSunday represent? Are you surprised that 42% of fatalities occur on those days? How mightdata for the number of cars on the road on those days possibly change or reinforce thatperception?2. An article in a Midwestern newspaper about flight delays at a major airport said: ‘According to aGannet News Service study of US airline’s performance during the past five months, Chicago’sO’Hare Field scheduled 114,370 flights. Nearly 10%, 1,136 were canceled.’ Check the paper’sarithmetic. What percent of scheduled flights were actually cancelled?3. The number of Americans living below the poverty line increased from 24,975,000 to 43,569,000in the 34 years between 1976 and 2009. What percentage increase was this? You should notconclude from this that poverty grew more common in the US during these years. Why not?4. Do a search for ‘dubious statistics’ on the web. Select one of the articles. Describe the dubioususe of statistics in the cited research. What makes the use of stats dubious in the case youchose?5. Go to the website http://www.census.gov/ and select a statistic they measure to analyze. It’spreferable to choose something that changes over time. Choose two data points and describethe percentage change between them. Be sure to clearly state that statistics you are using andthe dates associated with them.6. Create a pie chart for the following data. Copy the data into Excel and create a summary tableto start. A sample of 20 students who had recently taken elementary statistics yielded thefollowing information on the brand of calculator owned (T=Texas Instrument, H=HewlettPackard, C=Casio, S=Sharp). Be sure that your graph is properly labeled, displays the percentsand has a title.T T H T C T T S C HS S T H C T T T H T7. Below are a series of graphs. Interpret the graph. For time series graphs compare informationfrom two points in time and say something about the information obtained from the graph. Isthere a better way of displaying the data that might make the comparison you choose moresalient? Explain what kind of graph you are looking at. If this qualifies as a ‘bad graph’ what isbad about it?a)b)c)d)e)f)g)h)8. Using the Excel file 154data2.xlsx to answer the questions below:a. Create a comparative Bar Graph of States of Birth for American Presidents, and a separateone for the state they represented at the time they were elected. Write a paragraphsummarizing the graphs.b. Use the data on the Favorite Day to Eat Out to create a pie or donut graph of the data. Besure it is properly labeled and is easy to understand. Write a sentence or two thatsummarizes the result.c. Use the data on percent of poverty on the third sheet to create a line graph of the data.d. Use the same data to calculate the percent change from year to year. Then make a linegraph of the resulting data. Note: Percent change should be signed, so that an increase willbe positive, and a decrease will be negative. Make sure your line graphs have axis labels, atitle and are easy to read.