Business Analytics
3rd Edition
ISBN: 9780135231715
Author: Evans
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 4, Problem 71PE
To determine
To analyze:the sample data and write a report to the manager explaining the findings and conclusions.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
You are conducting a study of students doing work-study jobs on your campus. Among the questions on the survey instrument are: A. How many hours are you scheduled to work each week? Answer to the nearest hour. B. How applicable is this work experience to your future employment goals? Respond using the following scale: 1 = not at all, 2 = somewhat, 3 = very
What is the variable for question B? Classify the variable as qualitative or quantitative. What is the level of measurement (nominal, ordinal, interval, ratio)? Explain
- х
i
Data Table
ets
he
Full data set O
Assets
R&D Expense
R&D Expense
712.087
Assets
3,478.557
3,462.224
1,206.455
345.709
7,785.525
389.959
918.899
90.404
117.895
2,390.016
257.571
446.339
47.523
678.531
71.401
1,069.117
2,465.859
3,945.287
168.631
111.724
2,648.273
3,406.446
9,250.323
292.876
224.715
383.186
nt
410.051
988.349
19.257
485.204
55.161
493.116
55.046
2,363.477
251.699
0)
102.148
13.489
221.321
27.958
3,728.419
1,389.377
1,706.486
327.691
1,465.861
158.293
141.616
165.093
19.154
161.317
2,988.141
301.803
nat
Print
Done
The attached screenshot is a dataset representing responses to a job satisfaction survey of 50 hospital nurses throughout the U.S. Each respondent indicated his/her degree of satisfaction with three aspects: the work, pay, and opportunities for promotion. Each variable is measured on a scale of 0 to 100, with 100 representing the highest level of satisfaction. Use the data to answer the following questions using your choice of technology.
Answer ALL the questions below.
1. Find the following descriptive measures for each of the three variables.
a. mean
b. median
c. minimum
d. maximum
e. 90th percentile
f. IQR
g. range
h. standard deviation
2. Create and interpret a histogram of the satisfaction in pay variable.
3. Create and interpret a boxplot of the opportunities for promotion variable.
4. For questions a – d below, indicate the statistical measures/techniques that helped you answer the question.
a. Based on the survey results, which aspect of the job do the nurses find most…
Chapter 4 Solutions
Business Analytics
Ch. 4 - Prob. 1PECh. 4 - Classify each of the data elements in the Sales...Ch. 4 - Identify each of the variables in the Excel file...Ch. 4 - Classify each of the variables in the Excel file...Ch. 4 - Use the COUNTIF function to construct a frequency...Ch. 4 - A community health status survey obtained the...Ch. 4 - Construct frequency distributions and histograms...Ch. 4 - Use the Histogram tool to develop a frequency...Ch. 4 - Prob. 12PECh. 4 - Use a PivotTable to construct a frequency...
Ch. 4 - Prob. 14PECh. 4 - Find the 20thand80th percentiles of home prices in...Ch. 4 - Find the 10thand90th percentiles and the first and...Ch. 4 - Prob. 18PECh. 4 - Find the first, second, and third quartiles for...Ch. 4 - Prob. 20PECh. 4 - Prob. 21PECh. 4 - Find the mean, median, and midrange for the data...Ch. 4 - In the Excel file Facebook Survey, find the mean,...Ch. 4 - Considering the data in the Excel file Home Market...Ch. 4 - Considering the data in the Excel file Home Market...Ch. 4 - In the Excel file Facebook Survey, find the range,...Ch. 4 - For the Excel file Tablet Computer Sales, find the...Ch. 4 - The Excel file Atlanta Airline Data provides...Ch. 4 - Compute the coefficient of variation for each...Ch. 4 - Find 30 days of stock prices for three companies...Ch. 4 - Apply the Descriptive Statistics tool for subsets...Ch. 4 - Use the Descriptive Statistics tool to summarize...Ch. 4 - Prob. 39PECh. 4 - Prob. 42PECh. 4 - Prob. 43PECh. 4 - Prob. 44PECh. 4 - Prob. 45PECh. 4 - In the Excel file Bicycle Inventory, find the...Ch. 4 - Prob. 48PECh. 4 - Prob. 49PECh. 4 - Prob. 50PECh. 4 - Prob. 51PECh. 4 - Prob. 52PECh. 4 - Prob. 55PECh. 4 - Prob. 56PECh. 4 - Prob. 57PECh. 4 - Prob. 58PECh. 4 - Prob. 59PECh. 4 - In the Excel file Weddings, determine the...Ch. 4 - Prob. 61PECh. 4 - Prob. 62PECh. 4 - For the Presidents Inn Guest Database, find the...Ch. 4 - For the Excel file Credit Risk Data, compute the...Ch. 4 - Compute the z-scores for the data in the Excel...Ch. 4 - Prob. 67PECh. 4 - Prob. 68PECh. 4 - Prob. 70PECh. 4 - Prob. 71PECh. 4 - Prob. 73PECh. 4 - Prob. 74PECh. 4 - Prob. 75PE
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- Background information: Allison collected additional days of data to monitor the process. Steps to monitor using the control charts: Now monitor the process. An additional ten days of data have been collected, see table labeled “1st 10 Days of Monitoring Reservation Processing Time” in the Data File. Develop Xbar and R charts for the 1st 10 days of monitoring. Plot the data for the 1st 10 days on the Xbar and R charts. Is the process in control? If the control chart indicates an out-of-control process, note which days, the pattern, and whether it is the Xbar or R chart. Now that we have set up the control charts using enough data from a stable process, the 30 days of data, we will monitor the process. While monitoring the process, what will we use as the upper control limit for the R (range) Chart to compare against our new range values? Enter your response to three decimal places. You do not need to include the units (minutes), ONLY the numeric value. USE EXCELL DATA TO GET…arrow_forwardThe brand manager for a brand of toothpaste must plan a campaign designed to increase brand recognition. He wants to first determine the percentage of adults who have heard of the brand. How many adults must he survey in order to be 95% confident that his estimate is within five percentage points of the true population percentage? Complete parts (a) through (c) below. Question content area bottom Part 1 a) Assume that nothing is known about the percentage of adults who have heard of the brand. n=enter your response here (Round up to the nearest integer.) Part 2 b) Assume that a recent survey suggests that about 80% of adults have heard of the brand. n=enter your response here (Round up to the nearest integer.) Part 3 c) Given that the required sample size is relatively small, could he simply survey the adults at the nearest college? A. No, a sample of students at the nearest college is a cluster sample, not a simple random sample, so it is…arrow_forwardThe brand manager for a brand of toothpaste must plan a campaign designed to increase brand recognition. He wants to first determine the percentage of adults who have heard of the brand. How many adults must he survey in order to be 95% confident that his estimate is within five percentage points of the true population percentage? Complete parts (a) through (c) below. Question content area bottom Part 1 a) Assume that nothing is known about the percentage of adults who have heard of the brand. n=enter your response here (Round up to the nearest integer.)arrow_forward
- Solve the following problems and answer the following questions, based upon the following context, recording your responses here in this online test feature. Using appropriate technology is expected. Pay careful attention to requested levels of precision when reporting answers. The management at Fitness Fanatics Gym & Health Club has recently proposed four new levels of memberships: bronze, silver, gold and platinum. They surveyed current members in order to anticipate have they might respond to this change in membership plans. The results indicating their preferred level of membership were as follows: Bronze Silver Gold Platinum 60 40 80 120 The management had previously anticipated that the Bronze and Silver membership levels would each attract half as many members as the Gold and Platinum membership levels. At the 1% level of significance, test the claim that the preferences for membership levels adhered to the anticipated breakdown as the…arrow_forwardSolve the following problems and answer the following questions, based upon the following context, recording your responses here in this online test feature. Using appropriate technology is expected. Pay careful attention to requested levels of precision when reporting answers. The management at Fitness Fanatics Gym & Health Club has recently proposed four new levels of memberships: bronze, silver, gold and platinum. They surveyed current members in order to anticipate have they might respond to this change in membership plans. The results indicating their preferred level of membership were as follows: Bronze Silver Gold Platinum 60 40 80 120 The management had previously anticipated that the Bronze and Silver membership levels would each attract half as many members as the Gold and Platinum membership levels. At the 1% level of significance, test the claim that the preferences for membership levels adhered to the anticipated breakdown as the…arrow_forwardSolve the following problems and answer the following questions, based upon the following context, recording your responses here in this online test feature. Using appropriate technology is expected. Pay careful attention to requested levels of precision when reporting answers. The management at Fitness Fanatics Gym & Health Club has recently proposed four new levels of memberships: bronze, silver, gold and platinum. They surveyed current members in order to anticipate have they might respond to this change in membership plans. The results indicating their preferred level of membership were as follows: Bronze Silver Gold Platinum 60 40 80 120 The management had previously anticipated that the Bronze and Silver membership levels would each attract half as many members as the Gold and Platinum membership levels. At the 1% level of significance, test the claim that the preferences for membership levels adhered to the anticipated breakdown as the…arrow_forward
- Solve the following problems and answer the following questions, based upon the following context, recording your responses here in this online test feature. Using appropriate technology is expected. Pay careful attention to requested levels of precision when reporting answers. The management at Fitness Fanatics Gym & Health Club has recently proposed four new levels of memberships: bronze, silver, gold and platinum. They surveyed current members in order to anticipate have they might respond to this change in membership plans. The results indicating their preferred level of membership were as follows: Bronze Silver Gold Platinum 60 40 80 120 The management had previously anticipated that the Bronze and Silver membership levels would each attract half as many members as the Gold and Platinum membership levels. At the 1% level of significance, test the claim that the preferences for membership levels adhered to the anticipated breakdown as the…arrow_forwardSolve the following problems and answer the following questions, based upon the following context, recording your responses here in this online test feature. Using appropriate technology is expected. Pay careful attention to requested levels of precision when reporting answers. The management at Fitness Fanatics Gym & Health Club has recently proposed four new levels of memberships: bronze, silver, gold and platinum. They surveyed current members in order to anticipate have they might respond to this change in membership plans. The results indicating their preferred level of membership were as follows: Bronze Silver Gold Platinum 60 40 80 120 The management had previously anticipated that the Bronze and Silver membership levels would each attract half as many members as the Gold and Platinum membership levels. At the 1% level of significance, test the claim that the preferences for membership levels adhered to the anticipated breakdown as the…arrow_forwardSolve the following problems and answer the following questions, based upon the following context, recording your responses here in this online test feature. Using appropriate technology is expected. Pay careful attention to requested levels of precision when reporting answers. The management at Fitness Fanatics Gym & Health Club has recently proposed four new levels of memberships: bronze, silver, gold and platinum. They surveyed current members in order to anticipate have they might respond to this change in membership plans. The results indicating their preferred level of membership were as follows: Bronze Silver Gold Platinum 60 40 80 120 The management had previously anticipated that the Bronze and Silver membership levels would each attract half as many members as the Gold and Platinum membership levels. At the 1% level of significance, test the claim that the preferences for membership levels adhered to the anticipated breakdown as the…arrow_forward
- GreenLawns provides a lawn fertilizer and weed control service. The company is adding a special aeration treatment as a low-cost extra service option, which it hopes will help attract new customers. Management is planning to promote this new service in two media: radio and direct-mail advertising. A media budget of $3,500 is available for this promotional campaign. Based on past experience in promoting its other services, GreenLawns obtained the following estimate of the relationship between sales and the amount spent on promotion in these two media. S = −2R2 − 10M2 − 8RM + 18R + 34M where S = total sales in thousands of dollars R = thousands of dollars spent on radio advertising M = thousands of dollars spent on direct-mail advertising. GreenLawns would like to develop a promotional strategy that will lead to maximum sales subject to the restriction provided by the media budget. (a) What is the value of sales (in dollars) if $2,500 is spent on radio advertising and $1,000 is…arrow_forwardAs a sales analyst for the shoe retailer Foot Locker, one of your responsibilities is measuring store productivity and then reporting your conclusion back to management. Foot Locker uses sales per square foot as a measure of store productivity. While preparing your report for the second quarter results (Q2), you are able to determine that annual sales for last year ran at a rate of $406 per square foot. Therefore, $406 per square foot will be your sales estimate for the population of all Foot Locker stores during Q2. For your Q2 Sales Report, you decide to take a random sample of 64 stores. Using annual data from last year, you are able to determine that the standard deviation for sales per square foot for all 3,400 stores was $80. Therefore $80 per square foot will be your population standard deviation when compiling your Q2 report. Management has asked for the probability that your sample mean based on 64 stores is 1) within $15 and 2) within $5 of the population mean…arrow_forwardGreenLawns provides a lawn fertilizer and weed control service. The company is adding a special aeration treatment as a low-cost extra service option, which it hopes will help attract new customers. Management is planning to promote this new service in two media: radio and direct-mail advertising. A media budget of $3,500 is available for this promotional campaign. Based on past experience in promoting its other services, GreenLawns obtained the following estimate of the relationship between sales and the amount spent on promotion in these two media. S-2R²10M²8RM +18R+ 34M where GreenLawns would like to develop a promotional strategy that will lead to maximum sales subject to the restriction provided by the media budget. (a) What is the value of sales (in dollars) if $2,000 is spent on radio advertising and $1,500 is spent on direct-mail advertising? S = $ |x S = total sales in thousands of dollars R thousands of dollars spent on radio advertising M = thousands of dollars spent on…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
What Are Research Ethics?; Author: HighSchoolScience101;https://www.youtube.com/watch?v=nX4c3V23DZI;License: Standard YouTube License, CC-BY
What is Ethics in Research - ethics in research (research ethics); Author: Chee-Onn Leong;https://www.youtube.com/watch?v=W8Vk0sXtMGU;License: Standard YouTube License, CC-BY