# Statistics for Business Assignment Excel Work 2

1. Results of a customer satisfaction study for ABC Software were summarized by market are above (8 Points)
1. Construct a bar chart to summarize the results from Market A
2. Construct a pie chart to summarize the results from Market B
3. Based on the above, how do most customers in Market A feel about the latest upgrade?
4. Based on the above, 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. Based on the table, use a pie chart to summarize this variable graphically. (4 Points)
3. Use the data in BUSI1013-Case.xls to answer this question: (10 Points)
1. Construct a frequency distribution (classes 18-25, 26-35, 36-45, 46-55, 56-65, 66-75) for the variable Age
2. A relative frequency distribution for Age
3. A cumulative relative frequency distribution for Age
4. Construct a histogram for age using the frequency distribution in Part a.
5. What does the histogram tell us about the shape of the distribution of age (skewed to right, symmetric, etc.)
6. Use the data in BUSI1013-Numerical Data.xls to answer this question: (6 Points)
1. Construct a stem-and-leaf display for the variable Income. Please be sure to include a leaf unit,
2. Construct a stem-and-leaf display for the variable Number of transactions. Please be sure to include a leaf unit,
3. What does the stem-and-leaf display tell us about the shape of the distribution of Income?
7. Use the data in BUSI1013-Numerical Data.xls to answer this question: (10 Points)
1. What is the sample mean income?
2. What is the sample median income?
3. What is the sample mode for income?
4. Compute the 40th percentile for income.
5. Compute the first and third quartile for income.
8. Use the data in BUSI1013-Numerical Data.xls to answer this question (14 Points)
1. Find the range of the number of transactions
2. Find the sample standard deviation of the number of transactions
3. Compute the first and third quartile of the number of transactions
4. What is the IQR for the number of transactions?
5. Give the five-number summary for the number of transactions
6. Are there any outliers for the number of transactions? Use the IQR rule.
7. Use the z score method to check whether there is any outliers for the number of transactions.
9. Use the data in BUSI1013-Case.xls and the description of the case in the Week 1 Assignment to answer this question. (4 Points for each of the Questions, Total 12 Points)
1. 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)
2. 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)
3. Based on the above, would you consider the pilot to be successful for increasing the amount of deposits from members of the Credit Union?
Attachments:

Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]