1. Use the Histogram tool to construct a frequency distribution of lunch sales amounts in the Restaurant Sales database. (2 Points) 2. Use the Histogram tool to develop a frequency distribution and histogram with six bins for the age of individuals in the Excel file Credit Risk Data. Compute the relative and cumulative relative frequencies and use a line chart to construct an ogive. (4 Points) 3. The Excel sheet Sampling contains the responses on a scale of 1 to 5 from consumers regarding a product. Construct a pivot table and show the sampling data in the histogram. (2 Points) 4. Find the 20th and 80th percentiles of home prices in the Excel file Home Market Value. (2 Points) 5. Use Pivot Tables to construct a cross-tabulation for marital status and housing type in the Excel file Credit Risk Data. Illustrate the results on a PivotChart. (3 Points) 6. Create a PivotTable to find the average amount of travel expenses for each sales representative in the Excel file Travel Expenses. Illustrate your results with a PivotChart. (3 Points) 7. In the Excel file Facebook Survey, find the average and median hours online/week and number of friends in the sample using the appropriate Excel functions. Compute the midrange as well. (3 Points) 8. For the Excel file Tablet Computer Sales, find the average number, standard deviation, and interquartile range of units sold per week. (3 Points) 9. Use the Descriptive Statistics tool to summarize the mean, median, variance, and standard deviation of the prices of shares in the Excel file Coffee Shares Data. (4 Points) 10. In the Excel file Weddings, determine the correlation between the wedding costs and attendance. (1 Point) 11. For the data in the Excel file Rin's Gym, find the covariances and correlations among height, weight, and BMI calculation. (6 Points) 12. Compute the z-scores for the data in the Excel file Airport Service Times. How many observations fall farther than three standard deviations from the mean? (2 points) 1. Use the Histogram tool to construct a frequency distribution of lunch sales amounts in the Restaurant Sales database. (2 Points) 2. Use the Histogram tool to develop a frequency distribution and histogram with six bins for the age of individuals in the Excel file Credit Risk Data. Compute the relative and cumulative relative frequencies and use a line chart to construct an ogive. (4 Points) 3. The Excel sheet Sampling contains the responses on a scale of 1 to 5 from consumers regarding a product. Construct a pivot table and show the sampling data in the histogram. (2 Points) 4. Find the 20th and 80th percentiles of home prices in the Excel file Home Market Value. (2 Points) 5. Use Pivot Tables to construct a cross-tabulation for marital status and housing type in the Excel file Credit Risk Data. Illustrate the results on a PivotChart. (3 Points) 6. Create a PivotTable to find the average amount of travel expenses for each sales representative in the Excel file Travel Expenses. Illustrate your results with a PivotChart. (3 Points) 7. In the Excel file Facebook Survey, find the average and median hours online/week and number of friends in the sample using the appropriate Excel functions. Compute the midrange as well. (3 Points) 8. For the Excel file Tablet Computer Sales, find the average number, standard deviation, and interquartile range of units sold per week. (3 Points) 9. Use the Descriptive Statistics tool to summarize the mean, median, variance, and standard deviation of the prices of shares in the Excel file Coffee Shares Data. (4 Points) 10. In the Excel file Weddings, determine the correlation between the wedding costs and attendance. (1 Point) 11. For the data in the Excel file Rin's Gym, find the covariances and correlations among height, weight, and BMI calculation. (6 Points) 12. Compute the z-scores for the data in the Excel file Airport Service Times. How many observations fall farther than three standard deviations from the mean? (2 points)