Assignment 2 - Due on Dec 6 midnight This assignment has two parts : Part 1: Superstore 1. Use this Superstore data for your homework: Superstore QBAPro.xlsxDownload Superstore QBAPro.xlsx 2. Go to this link and attempt the questions for this homework there: Questions for Assignment 1 3. After taking the above quiz, come back here and submit the Excel work you did to answer these questions. Some of the questions are True/False type. You do not have to address those in the Excel file you submit. Make sure your file and sheets are well labeled. Part 2 : Soap Companies Read the case - Soap Companies Do Battle.pdf and answer the Questions mentioned at the end of the file. Here is the data set -SOAP COMPANIES Descriptive Statistics_Plots.xlsx Below is the snippet of questions picked from the case file. 1. What do you observe about the market shares of the various companies by studying the graphs? In particular, how is Procter & Gamble doing relative to previous years? 2. Construct a histogram to represent these data. What do you see in the graph that might be helpful to the production (and sales) people? Refer to the data provided with this case. Construct a stem-and-leaf plot using the whole numbers as the stems. What advantages does the stem-and-leaf plot of these sales figures offer over the histogram? What are some disadvantages? Which would you use in discussions with production people, and why? 3. Use a Pareto chart to analyze these problem causes. Based on your findings, what would you recommend to the company? Refer to the data provided for building the pareto chart.

pur-new-sol

Related Questions