Question: Heat maps can be very useful for identifying missing data values in moderate to large data sets. The file Surveyresults contains the responses from a

Heat maps can be very useful for identifying missing data values in moderate to large data sets. The file Surveyresults contains the responses from a marketing survey: 108 individuals responded to the survey of 10 questions. Respondents provided answers of 1, 2, 3, 4, or 5 to each question, corresponding to the overall satisfaction on 10 different dimensions of quality. However, not all respondents answered every question.
a. To find the missing data values, create a heat map in Excel that shades the empty cells a different color. Use Excel’s Conditional Formatting function to create this heat map.
b. For each question, which respondents did not provide answers? Which question has the highest nonresponse rate?

Step by Step Solution

★★★★★

3.43 Rating (172 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a The screen shot below shows the first 15 respondents of the survey results with the blank cel... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

611-M-S-D-A (4956).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

Regression techniques can be very useful in situations where one variablesay, yis difficult to measure but x is not. Once such an xy-relationship has been calibrated, based on a set of (xi , yi)s,...

The average is a commonly reported statistic. This single bit of information can be very informative or very misleading, with the mean and median being the two most commonly reported. a. The mean is...

Play the role of Chris Gray and construct a classification model to identify customers who are likely to respond to a mailing. your report should include the following analyses: 1. The data provided...

19. Marketing Survey Results. Heat maps can be very useful for identifying missing data values in moderate to large data sets. The file SurveyResults contains the responses from a marketing survey:...

Confirming Pages C H A P T E R 19 Analyzing Information and Writing Reports Chapter Outline Using Your Time Efficiently Analyzing Data and Information for Reports Identifying the Source of the Data...

Ferrell & Gresham (1985), A Contingency Framework for Understanding Ethical Decision Making in Marketing, Journal of Marketing, Vol. 49 (Summer), pp. 87-96. Just Try and Social Distance This,...

Omaha Steaks Which of the following choices best summarizes the strengths and weaknesses of this visualization? The choropleth map does a good job of depicting the geographic distribution of beef...

Business Research MethodologyQuestion Bank 1 1. When the marketing department of an organization attempts to determine the amount of time the managers in this department spend at their computers in...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

3.If an electric current is passed through a solution of molten potassium bromide, KBr, the product at the cathode is _____. Answer: 4. When a secondary battery provides electrical energy, it is...

The surface of planet Earth loses energy to outer space due mostly to (a) conduction. (b) convection. (c) radiation. (d) radioactivity.

What is the rate of return on an investment of $ 1 6 , 2 7 8 if the company expects to receive $ 3 , 0 0 0 per year for the next ten years? a . 1 3 % b . 1 5 % c . 1 8 % d . - 1 5 %

When notes and deeds of trust are sold, they are most often purchased at a a. discount. b. face amount. c. par amount. d. usury value.

Statewide Auto Insurance believes that for every trip longer than 10 minutes that a teenager drives, there is a 1 in 1,000 chance that the drive will results in an auto accident. Assume that the cost...

Galaxy Co. distributes wireless routers to Internet service providers. Galaxy procures each router for $75 from its supplier and sells each router for $125. Monthly demand for the router is a normal...

Using simulation software such as Analytic Solver Platform, develop a simulation model for the Sanotronics problem that was presented in Section 14.2 using native Excel functionality. a. Obtain...

A loan with the following terms is being made: Fixed rate, constant monthly payment. Closing date February 9th. Five percent interest rate. Prepaid interest due at closing. $120,000 mortgage loan...

(20 points) Your company is considering a five-year project to boost your sales. By purchasing a new machine, you expect to increase sales by X units in years 1 through 5. The per unit price is $70,...

In ZIMS store the manager is interested in determining which items sell well together. The manager assigned you this task and you opted for using Apriori Algorithm for finding the frequent item sets...