Students are to complete the exercises in Word (or some other compatible word processor) and submit. Results of a customer satisfaction study for ABC Software were summarized by market area below. (8...

Students are to complete the exercises in Word (or some other compatible word processor) and submit. Results of a customer satisfaction study for ABC Software were summarized by market area below. (8 points) 1. Overall, are you satisfied with the latest upgrade? Market A Market B Very satisfied 56 48 Satisfied 172 145 Neutral 32 30 Dissatisfied 26 27 Very dissatisfied 15 10 a.Construct a bar chart to summarize the results from Market A. b.Construct a pie chart to summarize the results from Market B. c.Based on the above table, how do most customers in Market A feel about the latest upgrade? d.Based on the above table, how do customers of ABC Software feel about the latest upgrade? 2.Use a frequency distribution table to numerically summarize the variable Branch in the BUSI1013-Case.xls data set (from Unit 1 Exercise Question 6). Based on the table, use a pie chart to summarize this variable graphically. (4 points) 3.Use the data in BUSI1013-Case.xls to complete and answer the following: (10 points) a.Construct a frequency distribution (classes 18-25, 26-35, 36-45, 46-55, 56-65, and 66-75) for the variable age. b.A relative frequency distribution for age. c.A cumulative relative frequency distribution for age. d.Construct a histogram for age using the frequency distribution in Part a. e.What does the histogram tell us about the shape of the distribution of age (skewed to right, symmetric, etc.)? 4.Use the data in BUSI1013-Numerical Data.xls to complete and answer the following: (6 points) a.Construct a stem-and-leaf display for the variable income. Please be sure to include a leaf unit. b.Construct a stem-and-leaf display for the variable number of transactions; be sure to include a leaf unit. c.What does the stem-and-leaf display tell us about the shape of the distribution of income? 5.Use the data in BUSI1013-Numerical Data.xls to answer these questions: (10 points) a.What is the sample mean income? b.What is the sample median income? c.What is the sample mode for income? d.Compute the 40th percentile for income. e.Compute the first and third quartile for income. 6.Use the data in BUSI1013-Numerical Data.xls to complete and answer the following: (14 points) a.Find the range of the number of transactions. b.Find the sample standard deviation of the number of transactions. c.Compute the first and third quartile of the number of transactions. d.What is the IQR for the number of transactions? e.Give the five-number summary for the number of transactions. f.Are there any outliers for the number of transactions? Use the IQR rule. g.Use the z score method to check whether there are any outliers for the number of transactions. 7.Use the data in and description of BUSI1013-Case.xls (from Unit 1 Exercise Question 6) to complete and answer the following: (4 points each, 12 points total) a.Summarize the variable Deposits Before (the Pilot) using the two measures of location (Mean and Median) and the two measures of variability (range and standard deviation). b.Summarize the variable Deposits After (the Pilot) using the two measures of location (Mean and Median) and the two measures of variability (range and standard deviation). c.Based on the above, would you consider the pilot to be successful for increasing the amount of deposits from members of the Credit Union?