Please Only Use excel to solve this problem and show all steps Please don't use someone else work on Chegg for this question or else i'll unlike the answer Again ONLY USE EXCEL AND SHOW WORK 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: Please Only Use excel to solve this problem and show all steps. Please don't use someone else work on Chegg for this question or else

Please Only Use excel to solve this problem and show all steps. Please don't use someone else work on Chegg for this question or else i'll unlike the answer. Again ONLY USE EXCEL AND SHOW WORK.

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!

(6A Question 1) PLEASE USE EXCEL TO SOLVE Can someone please show me how they got this answer? Thank you! Thomas Green is using net present value (NPV) when evaluating investment opportunities. His...

Here is a practice assingment that is giving me issues. Please use EXCEL to calculate the problem and show me the work. Later this week is the real assignment with different questions. But I would...

This is only one question but it has multiple parts. Please answer all parts and use the correct formulas and not Excel. Do NOT use Excel to solve the problems and show your work for each part. DW 2...

Please answer the below question and show Excel formulas , Excel tables need to be attached. 21) (35 pts) The Foundation for a university manages an endowment currently valued at $92 million. This...

Answer question 6 only. Please show all work and formula used and please dont use excel to solve. 1. What are the two sources of investment returns? Which kinds of investment returns have potential...

You are interested in obtaining a loan to buy a new automobile, and you must convince a banker that you have the money required to afford the car payment for the vehicle of your choice. The first...

Please read the New York Times article Googles Quest to Build a Better Boss and prepare your answers to the following questions: 1) Googles Project Oxygen approach to discovering what makes an...

G google translate(42,988 unread) D Home | KESU KEWeek 4 Case Stud G Identify the specifi G que aspectos lega xDenise Stubbs, the x+ & Apps G https://www.chegg.com/homework help/denise-Stubbs...

Requirement 1: ''As Is'' Process Map Using standard process mapping symbols and referring to the example process map presented in Appendix A, draw a process map for Elizor's raw materials purchasing...

Hello, This is the Fina 210 Course about Real estate. Could you help me to solve this problem and show me a solution? because i want to know how to solve this type of question in exam. Thank you! ps:...

QUESTION 1 Another name for a unity gain amplifier is difference amplifier single ended voltage follower comparator

Diffusion in two and three dimensions. (a) Show that the diffusion equation in two dimension admits the solution 2(t) = (C2/t)exp (-r2/4Dt) and in three dimensions (b) Evaluate the constants C2 and...

Discussion 4 : Identify Key Aspects of an Audit Report Subscribe Instructions Please select a public company that is interesting to you. Navigate to their most recent annual report and the audit...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...