For these problems please provide the answer as an excel file and each problem as its own sheet/worksheet.

Chapter 2 Organizing and Visualizing Variables 1. A study of selected Kickstarter projects showed that overall, a majority were successful, achieving their goal and raising, at a minimum, the targeted amounts. In an effort to identify project types that influence success, selected projects were subdivided into project categories. The results are as follows: (20 points) Outcome Category Successful Unsuccessful Total Film 17024 26857 43881 Games 5105 10075 15180 Music 19275 17050 36325 Technology 2556 8770 11326 Total 43960 62752 106712 a. Construct a contingency table based on... + total percentages, a contingency table based on row percentages, + a contingency table based on column percentages. You will need to show three tables. b. Create the following visual displays using the above information... a bar graph, + two pie charts (one for successful and one for unsuccessful), + a double doughnut graph 2. The file NBACost contains the total ($) for four average-priced tickets, two beers, four soft drinks, four hotdogs, two game programs, two adult-size caps, and one parking space at each of the 30 National Basketball Association arenas during the 2014-2015 season. These costs were: (20 points) 246.39 444,16 404.60 212.40 477.32 271.74 312.20 322.50 261.20 336.52 369.86 232.44 435.72 541.00 223.92 468.20 325.85 381.006 221.80 676.42 295.40 263.10 278.90 341.90 317.08 280.28 340.60 289.71 275.74 258.78 a. Please organize the costs above in Excel as follows: o a stem and leaf plot, o an ordered array, o frequency distribution (include frequency, relative frequency, percentages, cumulative frequency, and cumulative relative frequency, and cumulative percentages) b. Please visualize the costs above in Excel as follows: o a histogram (with midpoints) 3. Collect some data from a real-life situation. The data we will use for this example shows test scores received by 20 students. Information on the hours each student studied for the test is provided. Create a scatterplot of the data below. (5 points) Hours of 5 10 4 Study 8 12 9 10 12 15 12 12 20 16 14 22 18 30 21 28 24 Test 54 56 63 64 62 61 63 73 78 72 74 78 83 86 83 81 88 87 Scores 89 93 4. Make a time-series plot of the data. (5 points) Percent of Americans Owning Homes Year 1950 1960 1970 1980 1990 Percent 55.0% 61.9% 62.9% 64.4% 64.2%