Opening the 'Data for Midterm 1' Excel spreadsheet, you'll find a worksheet that gives you data on a sample of fifty people and their streaming preferences. The following questions pertain to that data. A. The first column tells you the person's favorite streaming service. What kind of data is this? B. The second column tells you how many minutes the person used that service the previous week. What kind of data is this? C. Using this data create the following tables and graphs: frequency tables, percent frequency tables, a cumulative frequency table, an ordered array, a histogram, a pie chart and a contingency table. (7 points) When you're making the frequency tables for the minutes column -- please be sure to put the data in groups of 200, starting at 0. (Also, remember, certain graphs can only be used for categorical variables, and certain graphs can only be used for quantitative variables. Thus, while you'll have to make a frequency table for both columns of data, you'll only need to make one histogram, one pie chart, one ordered array, one cumulative frequency table and one contingency table). When you're done please convert your Excel file into a pdf (review the demo video I've posted on the course website, if you need help), and upload it to the course website, using the assignment module in the Midterm 1 section -- the one called 'Midterm 1 -- Tables and Graphs'. D. Using the data from the second column (about how many minutes the person used their favorite streaming service the previous week) calculate the following values. Please round all answers to two decimal points.) Average