Project #90260 - EXCEL ASSIGNMENT - Making a Pareto chart from raw data. due in 4 hours. only bid if you know how to work with excel.

Hello. 

the assignment is supposed to be done through excel. so please only bid if you know your way around excel. 

this is the assignment

Problem Statement

You are working as Assistant Managers in a restaurant and the manager, upon hearing you studied Pareto Charts, assigns you the task of converting raw data (see attached Text file) from customer comments into a Pareto Chart. The manager asks you to do the following tasks using the raw data in the attached file, create a Pareto Chart.

1. Paste the raw data from the file Homework2.txt into a new Excel file and label the worksheet 'Customer Comments' (note: the first row in the raw data is the column header).  add a worksheet labeled 'Pareto Chart' and make it the first one in the spreadsheet.

2. Assign each of the customer comments to one of the following nine categories that have been provided the manager: ï‚· Cleanliness ï‚· Food Prep ï‚· Menu ï‚· Unknown ï‚· Other ï‚· Parking ï‚· Service ï‚· Website

3. Create a Pareto Chart based on the distribution of comments by categories. Note: this will require doing a Pivot Chart to count the number of records in each comment category. Follow the instructions shown in the video (5m 26s) at: https://www.youtube.com/watch?v=dMWq48_TsNo, which explains the chart mechanics in detail.

4. Once the Pareto Chart is complete, insert a textbox underneath it answer the following questions:

ï‚· What is the summary of what this chart shows?

ï‚· What do you think are likely the biggest problem areas for the restaurant and why?

ï‚· What are your recommendations?

ï‚· What is a significant limitation of the data in this particular chart (i.e., not a limitation of Pareto Charts in general)? What do you propose be done to alleviate this limitation?

--------------------------------------------------------------------

it is due in 4 hours. please only bid if you are familiar with excel. 

 

Subject Computer
Due By (Pacific Time) 10/31/2015 12:42 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy