Solve the 3 question Please use excel and show all steps 1 Create 4 Histograms for Each Attribute indicating counts of each response 2 Create Histogram of AVERAGE Quality in each region Best Region Worst Region 3 FOR DASHBOARD Histogram of AVERAGE of each attribute Customer Survey Attributes Region Quality Ease of Use Price Service NA 4 1 3 4 NA 4 4 4 5 NA 4 5 4 3 NA 5 4 4 4 NA 5 4 5 4 NA 5 5 3 5 NA 5 4 4 2 NA 5 5 4 5 NA 4 4 4 5 NA 4 5 4 5 NA 4 5 1 4 NA 5 5 4 4 NA 5 4 3 3 NA 4 5 4 4 NA 5 4 3 5 NA 5 5 2 5 NA 5 4 2 5 NA 5 4 2 5 NA 4 5 4 4 NA 4 4 5 4 NA 4 4 2 4 NA 4 3 3 4 NA 5 5 2 5 NA 5 3 4 3 NA 5 4 4 5 NA 5 5 2 5 NA 5 5 5 3 NA 4 4 5 4 NA 5 4 4 4 NA 5 1 5 5 NA 5 4 3 5 NA 4 5 1 4 NA 4 4 3 5 NA 5 3 4 4 NA 5 5 2 4 NA 5 4 4 4 NA 5 5 4 4 NA 5 5 4 5 NA 4 3 3 5 NA 5 4 4 3 NA 5 4 3 4 NA 5 5 1 5 NA 5 4 5 4 NA 3 4 3 4 NA 5 4 2 4 NA 5 5 4 5 NA 5 5 3 4 NA 5 4 4 4 NA 5 4 4 4 NA 5 4 4 5 NA 5 4 1 4 NA 5 4 5 5 NA 5 5 3 4 NA 5 4 4 5 NA 4 3 5 5 NA 5 4 4 4 NA 5 5 5 5 NA 5 5 4 5 NA 4 4 4 4 NA 5 4 5 5 NA 4 5 5 4 NA 5 5 5 4 NA 5 5 3 5 NA 5 4 4 4 NA 5 4 5 2 NA 4 4 5 5 NA 4 4 4 5 NA 5 4 4 4 NA 5 4 3 5 NA 5 4 5 4 NA 5 5 4 5 NA 5 4 4 4 NA 5 4 5 2 NA 5 3 4 5 NA 5 4 5 5 NA 5 4 1 5 NA 4 5 3 5 NA 3 5 2 5 NA 5 5 4 4 NA 4 4 3 5 NA 3 2 4 5 NA 1 4 3 4 NA 4 5 3 5 NA 5 5 4 4 NA 4 5 5 5 NA 5 5 4 5 NA 5 5 4 4 NA 4 2 4 5 NA 5 4 5 4 NA 5 4 5 4 NA 5 5 4 3 NA 5 5 5 5 NA 4 5 5 3 NA 5 5 4 5 NA 4 4 5 5 NA 5 5 3 4 NA 4 5 2 4 NA 5 5 5 4 NA 4 5 4 3 NA 4 5 5 4 SA 5 4 3 5 SA 5 4 2 4 SA 5 4 5 5 SA 4 2 4 5 SA 5 4 4 5 SA 4 5 2 5 SA 5 4 4 4 SA 4 5 3 5 SA 4 4 4 3 SA 4 4 2 4 SA 5 4 3 4 SA 3 3 5 5 SA 5 4 3 4 SA 5 4 2 5 SA 4 4 3 4 SA 4 4 3 5 SA 1 5 3 4 SA 5 4 2 4 SA 4 4 4 4 SA 4 4 5 5 SA 5 4 2 4 SA 4 4 5 5 SA 4 4 4 3 SA 3 3 4 5 SA 5 4 4 4 SA 4 4 4 1 SA 4 5 5 5 SA 4 1 4 5 SA 4 5 4 4 SA 4 4 4 5 SA 5 4 3 4 SA 4 4 4 5 SA 5 5 4 3 SA 5 5 4 4 SA 4 4 2 4 SA 4 4 4 5 SA 5 4 4 5 SA 5 4 4 4 SA 5 4 1 4 SA 3 4 4 5 SA 4 3 5 4 SA 4 4 2 3 SA 5 4 3 3 SA 4 3 4 5 SA 5 3 5 5 SA 5 4 4 4 SA 5 4 4 4 SA 3 4 3 4 SA 4 4 1 4 SA 4 3 4 3 Eur 4 5 5 3 Eur 4 4 4 2 Eur 3 4 5 4 Eur 3 4 1 3 Eur 4 4 5 5 Eur 5 5 5 5 Eur 5 5 5 1 Eur 4 5 5 4 Eur 3 4 4 4 Eur 3 5 3 3 Eur 4 4 5 4 Eur 5 4 5 5 Eur 5 3 4 4 Eur 5 5 4 5 Eur 3 4 4 4 Eur 4 5 4 5 Eur 4 5 4 4 Eur 5 4 4 5 Eur 4 5 4 4 Eur 3 5 3 4 Eur 4 4 4 2 Eur 5 5 3 4 Eur 5 3 4 5 Eur 4 5 2 4 Eur 4 3 4 4 Eur 5 4 3 3 Eur 2 4 4 4 Eur 5 4 5 4 Eur 4 5 4 3 Eur 5 4 1 5 Pac 5 4 4 5 Pac 5 5 5 5 Pac 4 4 4 4 Pac 4 3 4 4 Pac 5 4 5 4 Pac 4 4 4 4 Pac 5 5 4 5 Pac 4 2 3 3 Pac 3 4 4 4 Pac 5 4 4 5 China 5 5 4 4 China 5 5 4 3 China 4 4 3 3 China 4 4 3 3 China 4 4 3 2 China 4 4 3 3 China 4 4 3 2 China 3 4 3 3 China 3 4 2 2 China 2 3 2 1

The Answer is in the image, click to view ...

Question: Solve the 3 question. Please use excel and show all steps. 1. Create 4 Histograms for Each Attribute indicating counts of each response 2. Create

Solve the 3 question. Please use excel and show all steps.

1. Create 4 Histograms for Each Attribute indicating counts of each response

2. Create Histogram of AVERAGE Quality in each region. Best Region? Worst Region?

3. FOR DASHBOARD: Histogram of AVERAGE of each attribute

Customer Survey
	Attributes
Region	Quality	Ease of Use	Price	Service
NA	4	1	3	4
NA	4	4	4	5
NA	4	5	4	3
NA	5	4	4	4
NA	5	4	5	4
NA	5	5	3	5
NA	5	4	4	2
NA	5	5	4	5
NA	4	4	4	5
NA	4	5	4	5
NA	4	5	1	4
NA	5	5	4	4
NA	5	4	3	3
NA	4	5	4	4
NA	5	4	3	5
NA	5	5	2	5
NA	5	4	2	5
NA	5	4	2	5
NA	4	5	4	4
NA	4	4	5	4
NA	4	4	2	4
NA	4	3	3	4
NA	5	5	2	5
NA	5	3	4	3
NA	5	4	4	5
NA	5	5	2	5
NA	5	5	5	3
NA	4	4	5	4
NA	5	4	4	4
NA	5	1	5	5
NA	5	4	3	5
NA	4	5	1	4
NA	4	4	3	5
NA	5	3	4	4
NA	5	5	2	4
NA	5	4	4	4
NA	5	5	4	4
NA	5	5	4	5
NA	4	3	3	5
NA	5	4	4	3
NA	5	4	3	4
NA	5	5	1	5
NA	5	4	5	4
NA	3	4	3	4
NA	5	4	2	4
NA	5	5	4	5
NA	5	5	3	4
NA	5	4	4	4
NA	5	4	4	4
NA	5	4	4	5
NA	5	4	1	4
NA	5	4	5	5
NA	5	5	3	4
NA	5	4	4	5
NA	4	3	5	5
NA	5	4	4	4
NA	5	5	5	5
NA	5	5	4	5
NA	4	4	4	4
NA	5	4	5	5
NA	4	5	5	4
NA	5	5	5	4
NA	5	5	3	5
NA	5	4	4	4
NA	5	4	5	2
NA	4	4	5	5
NA	4	4	4	5
NA	5	4	4	4
NA	5	4	3	5
NA	5	4	5	4
NA	5	5	4	5
NA	5	4	4	4
NA	5	4	5	2
NA	5	3	4	5
NA	5	4	5	5
NA	5	4	1	5
NA	4	5	3	5
NA	3	5	2	5
NA	5	5	4	4
NA	4	4	3	5
NA	3	2	4	5
NA	1	4	3	4
NA	4	5	3	5
NA	5	5	4	4
NA	4	5	5	5
NA	5	5	4	5
NA	5	5	4	4
NA	4	2	4	5
NA	5	4	5	4
NA	5	4	5	4
NA	5	5	4	3
NA	5	5	5	5
NA	4	5	5	3
NA	5	5	4	5
NA	4	4	5	5
NA	5	5	3	4
NA	4	5	2	4
NA	5	5	5	4
NA	4	5	4	3
NA	4	5	5	4
SA	5	4	3	5
SA	5	4	2	4
SA	5	4	5	5
SA	4	2	4	5
SA	5	4	4	5
SA	4	5	2	5
SA	5	4	4	4
SA	4	5	3	5
SA	4	4	4	3
SA	4	4	2	4
SA	5	4	3	4
SA	3	3	5	5
SA	5	4	3	4
SA	5	4	2	5
SA	4	4	3	4
SA	4	4	3	5
SA	1	5	3	4
SA	5	4	2	4
SA	4	4	4	4
SA	4	4	5	5
SA	5	4	2	4
SA	4	4	5	5
SA	4	4	4	3
SA	3	3	4	5
SA	5	4	4	4
SA	4	4	4	1
SA	4	5	5	5
SA	4	1	4	5
SA	4	5	4	4
SA	4	4	4	5
SA	5	4	3	4
SA	4	4	4	5
SA	5	5	4	3
SA	5	5	4	4
SA	4	4	2	4
SA	4	4	4	5
SA	5	4	4	5
SA	5	4	4	4
SA	5	4	1	4
SA	3	4	4	5
SA	4	3	5	4
SA	4	4	2	3
SA	5	4	3	3
SA	4	3	4	5
SA	5	3	5	5
SA	5	4	4	4
SA	5	4	4	4
SA	3	4	3	4
SA	4	4	1	4
SA	4	3	4	3
Eur	4	5	5	3
Eur	4	4	4	2
Eur	3	4	5	4
Eur	3	4	1	3
Eur	4	4	5	5
Eur	5	5	5	5
Eur	5	5	5	1
Eur	4	5	5	4
Eur	3	4	4	4
Eur	3	5	3	3
Eur	4	4	5	4
Eur	5	4	5	5
Eur	5	3	4	4
Eur	5	5	4	5
Eur	3	4	4	4
Eur	4	5	4	5
Eur	4	5	4	4
Eur	5	4	4	5
Eur	4	5	4	4
Eur	3	5	3	4
Eur	4	4	4	2
Eur	5	5	3	4
Eur	5	3	4	5
Eur	4	5	2	4
Eur	4	3	4	4
Eur	5	4	3	3
Eur	2	4	4	4
Eur	5	4	5	4
Eur	4	5	4	3
Eur	5	4	1	5
Pac	5	4	4	5
Pac	5	5	5	5
Pac	4	4	4	4
Pac	4	3	4	4
Pac	5	4	5	4
Pac	4	4	4	4
Pac	5	5	4	5
Pac	4	2	3	3
Pac	3	4	4	4
Pac	5	4	4	5
China	5	5	4	4
China	5	5	4	3
China	4	4	3	3
China	4	4	3	3
China	4	4	3	2
China	4	4	3	3
China	4	4	3	2
China	3	4	3	3
China	3	4	2	2
China	2	3	2	1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

SHOW ALL WORKINGS ! Please use excel for all graphs Attached are pictures of the original graph But please use the numbers attached here as all the 8s and 2s were changed . 1. Daudi owns and manages...

Download and analyze the data in the CreditCard dataset. The following variables are included in the dataset: 1. card: was the application for a card accepted? (Binary: 1/0) Response Variable 2....

EMOTIONAL INTELLIGENCE ASSESSMENT Please reply to each item below by selecting the one alternative that is most likely to be your response. Think about the way you usually respond to these kinds of...

I need help from a Financial expert who is very familiar with exchange rate exposure & payout policy.I will adjust the price as you suggest. For some reason I am not able to do it here. Please be...

the data is too big in excel, i didn't post all. please use excel to explaine how to solve those question. Thanks! B2 1 E A F G H 1 Job time 2 3 4 5 Day 01 01 01 01 01 01 01 01 01 6 7 Mean 299.8579...

Question 2 Use the data provided in Question 1, the Analyst would like to establish a Linear regression model for the demand, Using Excel, please run linear regression on this data (1 mark) 2.1 2.2...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) to your instructor. The tabs (bottom of each sheet) in...

I have the d0cument with solution my prof. has provided it to us but I am unable to find the answers in my mac book. (down) please help me how to find the formula for each question that would be very...

Please help me understand the formulas needed for these steps. Carl's Construction Carl's existing customers and part-time employee's data are: CustomerName Your Own Name Sam Nichols Tom Hart Carl...

Wal Mart Stores; perpetuity growth model derivation of results in Chapter 6 Refer to the discussion on page 284 in Chapter 6. There, in estimating the value of a share of common stock of Wal-Mart...

Salva Pest Control disposed of four assets recently. Salvas accounting records provided the following information about the assets at the time of their disposal: The truck was sold for $2,000 cash,...

Work out the value of y in each shape. All measurements are in centimetres. Show how to check your answers are correct. a 4(y-3) 2y+2 b 8y-5 C 2(y+6) 4(y-3) 3(y+5) ||

8 ) Managers of the Chadwick Company want to identify an appropriate cost driver for the quality control overhead cost pool . Which of the following would be the most appropriate choice ? Number of...