Business Analytics (2nd Edition)
2nd Edition
ISBN: 9780321997821
Author: James R. Evans
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 4, Problem 37PE
To determine
To use charts and
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
A major software company is considering a price increase on its most popular product. They are currently selling below their competitor’s price. Someone from the Brand team suggested they check consumer response before making a price increase. You are called into explain how this marketing research might be carried out. In terms of qualitative and quantitative options you tell them...
A researcher wanted to know if there was a relationship between stress and frustration. Theresearcher recruited n = 5 participants and asked them to solve a difficult puzzle in a short timeperiod. She then asked each participant to rate how stressful the task was and how frustratedthey were to solve the puzzle on a scale of 1 to 5. The data are below:
Stress (X) Frustration (Y)
2 1
2 2
3 4
3 4
3 5
Calculate the sum of products
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 (2nd Edition)
Ch. 4 - Data obtained from a county auditor in the Excel...Ch. 4 - In the Excel file Facebook Survey, find the...Ch. 4 - For the Excel file Tablet Computer Sales, find the...Ch. 4 - Prob. 4PECh. 4 - Prob. 5PECh. 4 - Prob. 6PECh. 4 - Prob. 7PECh. 4 - Prob. 8PECh. 4 - Prob. 9PECh. 4 - Prob. 10PE
Ch. 4 - A marketing study of 800 adults in the 18—34 age...Ch. 4 - The Excel file EEO Employment Report shows the...Ch. 4 - In the Excell file Bicycle Inventory, find the...Ch. 4 - In the Sales Transactions database, find the...Ch. 4 - In the Excel file Economic Poll, find the...Ch. 4 - In the Excel file Facebook Survey, use a...Ch. 4 - In the Excel file Cell Phone Suivey, use...Ch. 4 - Using PivotTables, find the average and standard...Ch. 4 - Prob. 19PECh. 4 - Prob. 20PECh. 4 - Prob. 21PECh. 4 - Prob. 22PECh. 4 - Call centers have high turnover rates because of...Ch. 4 - In the Excel file Weddings, determine the...Ch. 4 - Prob. 25PECh. 4 - Prob. 26PECh. 4 - Prob. 27PECh. 4 - Prob. 28PECh. 4 - Prob. 29PECh. 4 - Prob. 30PECh. 4 - Prob. 31PECh. 4 - Compute the z-scores for the data in the Excel...Ch. 4 - Prob. 33PECh. 4 - Prob. 34PECh. 4 - Prob. 35PECh. 4 - Prob. 36PECh. 4 - Prob. 37PECh. 4 - Prob. 38PE
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
- As 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_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. You anticipate that management would be comfortable with a probability of 0.500 when offering your estimate of the sample mean. Using σ = $80…arrow_forwardYour younger brother, a fourth form practical geography student wishes to test whether there could be some relationship between annual visits to a local market by all residents surrounding that market. After a well-designed field study he obtains the following figures: Number of visits per year 21 13 19 18 17 17 14 20 10 11 Residence distance from market (KM) 1.0 2.0 3.0 4.0 5.0 6.0 7.0 8.0 9.0 10.0 From the information above, what is the dependent variable and what is the explanatory variable? Using (i) above, obtain the regression equation of Yi on Xi. Hence, estimate the residence distance from the market (in KM) if the number of visits are 16 visits Sketch your results in (ii) above. What conclusion can you draw from your sketch?arrow_forward
- A researcher wanted to know if there was a relationship between stress and frustration. Theresearcher recruited n = 5 participants and asked them to solve a difficult puzzle in a short timeperiod. She then asked each participant to rate how stressful the task was and how frustratedthey were to solve the puzzle on a scale of 1 to 5. The data are below: Stress (X) Frustration (Y) 2 1 2 2 3 4 3 4 3 5 Calculate Peason's rarrow_forwardQQQ3. Diamond PricesWeight 0.3 0.4 0.5 0.5 1.0 0.7Price 510 1151 1343 1410 5669 2277Find the best predicted price for this diamond with a weight of 1.50 carats. Is the result close tothe actual price of $16,097? What is wrong with predicting the price of a 1.50-carat diamond? Between the two variables.d) Find the regression equation,e) Letting the first variable be the predictor (x) variable, find the indicated predicted value.arrow_forwardTwo different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled water. Actual demand and the two sets of forecasts are as follows. The question asks whether the F1 or F2 forecast is more accurate, and what is the Mean Absolute Percentage Error. Show your work and answer the question. Be as succinct as possible please, you do not need to show me calculations for the wrong answers. Period Demand F1 F2 1 2 3 4 5 6 8 68 75 70 74 69 72 80 78 66 66 68 68 72 70 71 72 72 74 70 76 71 78 74 80 e1 3.0 2.0 7.0 7.0 -2.0 -3.0 2.0 Forecast F1 9.0 4.0 MAD MAPE MSE 2.0 2.9 4.0 9.3 49.0 2.0 2.9 4.0 3.0 4.1 9.0 3.0 4.3 9.0 2.0 2.8 4.0 9.0 11.3 81.0 4.0 5.1 16.0 e2 2.0 Forecast F2 MAD MAPE 2.0 2.9 9.3 7.0 7.0 0.0 0.0 2.0 2.0 0.0 2.7 5.0 7.2 -5.0 -4.0 4.0 5.6 2.0 2.0 2.5 -2.0 2.0 2.6 MSE 4.0 49.0 0.0 4.0 25.0 16.0 4.0 4.0arrow_forward
- You are assigned your first project and if things go well you should get promoted. The CEO is aware of this project, so you have a chance for high visibility. You want to do a good job! Your first task is to define the work break down structure by interviewing project activity managers and the firm's friendly, yet boring, accountants to get "good estimates of project activity times and costs. For one of the activities, the normal time is eight weeks, the crash time is three weeks, the normal cost is $7,870, and the crash cost is $17,110. What is the crash cost per week? Round your answer to the nearest dollar.arrow_forward1. Suppose that you estimate a model of house prices to determine the impact of having beach frontage on the value of a house.14 You do some research, and you decide to use the size of the lot instead of the size of the house for a number of theoretical and data availability rea- sons. Your results (standard errors in parentheses) are: PRICE; = 40 + 35.0 LOT¡ – 2.0 AGE; + 10.0 BED; – 4.0 FIRE; (1.0) (5.0) (10.0) (4.0) (10) N = 30 R2 =.63 where: PRICE¡ =the price of the th house (in thousands of dollars) =the size of the lot of the th house (in thousands of square feet) = the age of the th house in years =the number of bedrooms in the th house =a qualitative/dummy variable for a fireplace (1 = yes for the th house) LOT; AGE; BED; FIRE; a. You expect the variables LOT and BED to have positive coefficients. Create and test the appropriate hypotheses to evaluate these expectations at the 5-percent level. b. You expect AGE to have a negative coefficient. Create and test the appropriate…arrow_forwardData on average math and reading scores on a standardized test for a grade level, as well as the percentage of students below the poverty level, for a sample of 22 schools in a region are shown in the accompanying table. Complete part through e below. Click the icon to view the data on math and reading test scores. a. Propose a straight-line model relating math score (y) to percentage (x) of students below the poverty level. Choose the correct answer b A. Y=B₁x + ε B. Y=B₁x C. Y=B₁ + B₁x + ε OD. Y=B₁x² +³₁ + ε b. Use the method of least squares to fit the model to the data. = = + Ox (Round to two decimal places as needed.) c. Graph the least squares line on a scatterplot of the data. Is there visual evidence of a relationship between the two variables? Is the rela Choose the correct plot below. Math Score A. 200 1740 140+ 0 % Below Poverty 100 O Math Score B. 200 140+ 0 % Below Poverty 100 Is there visual evidence of a relationship between the two variables? Is the relationship…arrow_forward
- Lovely Lawns, Inc., intends to use sales of lawn fertilizer to predict lawn mower sales. The store manager estimates a probable six- week lag between fertilizer sales and mower sales. The pertinent data are: Fertilizer Number of Fertilizer Number of Sales Mowers Sold Sales Mowers Sold Period (tons) (six-week lag) Period (tons) (six-week lag) 1 1.6 10 8. 1.3 7 1.3 8 1.7 10 3 1.8 11 10 1.2 6. 4 2.0 12 1.9 11 2.2 12 12 1.4 1.6 9. 13 1.7 10 7 1.5 14 1.6 a. Determine the correlation between the two variables. Does it appear that a relationship exists between these variables will yield good predictions? (Do not round intermediate calculations and round your answer to 3 decimal places.) it appears that a positive v relationship exists between these variables. b. Obtain a linear regression line for the data. (Negative values should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 3 decimal places.) Y = O Xi + c. Predict expected lawn mower sales…arrow_forwardSleep Late, a large hotel chain, has been using activity-based costing to determine the cost of a night’s stay at their hotels. One of the activities, “Inspection,” occurs after a customer has checked out of a hotel room. Sleep Late inspects every 10th room and has been using “number of rooms inspected” as the cost driver for inspection costs. A significant component of inspection costs is the cost of the supplies used in each inspection Mary Adams, the chief inspector, is wondering whether inspection labor-hours might be a better cost driver for inspection costs. Mary gathers information for weekly inspection costs, rooms inspected, and inspection labor-hours as follows: Q.Plot the data and regression line for rooms inspected and inspection costs. Plot the data and regression line for inspection labor-hours and inspection costs. Which cost driver of inspection costs would you choose? Explain.arrow_forwardGreenLawns provides a lawn fertilizing 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 $2,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 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,000 is spent on radio advertising and $500 is 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 HillBig 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
Statistics 4.1 Point Estimators; Author: Dr. Jack L. Jackson II;https://www.youtube.com/watch?v=2MrI0J8XCEE;License: Standard YouTube License, CC-BY
Statistics 101: Point Estimators; Author: Brandon Foltz;https://www.youtube.com/watch?v=4v41z3HwLaM;License: Standard YouTube License, CC-BY
Central limit theorem; Author: 365 Data Science;https://www.youtube.com/watch?v=b5xQmk9veZ4;License: Standard YouTube License, CC-BY
Point Estimate Definition & Example; Author: Prof. Essa;https://www.youtube.com/watch?v=OTVwtvQmSn0;License: Standard Youtube License
Point Estimation; Author: Vamsidhar Ambatipudi;https://www.youtube.com/watch?v=flqhlM2bZWc;License: Standard Youtube License