Essentials Of Business Analytics
1st Edition
ISBN: 9781285187273
Author: Camm, Jeff.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 5, Problem 20P
The Seneca Children’s Fund (SCF) is a local charity that runs a summer camp for disadvantaged children. The fund’s board of directors has been working very hard over recent years to decrease the amount of overhead expenses, a major factor in how charities are rated by independent agencies. The following data show the percentage of the money SCF has raised that was spent on administrative and fund-raising expenses over the past seven years:
- a. Construct a time series plot. What type of pattern exists in the data?
- b. Use simple linear
regression analysis to find the parameters for the line that minimizes MSE for this time series. - c. Forecast the percentage of administrative expenses for year 8.
- d. If SCF can maintain its current trend in reducing administrative expenses, how long will it take SCF to achieve a level of 5% or less?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
. Primary Data Source and Secondary Data Source ?
Which type of data source provides real-time data?
A. Historical data
B. Survey data
C. Transactional data
D. Social media data
The following table gives the annual revenue for the Microsoft Corp. in billions of dollars for a ten-year period.
Year
Microsoft
2007
2008
51
60
2009
2010
58
62
2011
2012
70
73
2013
2014
2015
2016
78
86
94
85
Construct and upload a boxplot for the Microsoft data. Be sure to label all the important numbers for the box plot.
Chapter 5 Solutions
Essentials Of Business Analytics
Ch. 5 - Consider the following time series data:
Using...Ch. 5 - Refer to the time series data in Problem 1. Using...Ch. 5 - Problems 1 and 2 used different forecasting...Ch. 5 - Consider the following time series data:
Compute...Ch. 5 - Consider the following time series...Ch. 5 - Consider the following time series...Ch. 5 - Prob. 8PCh. 5 - Prob. 9PCh. 5 - Prob. 10PCh. 5 - For the Hawkins Company, the monthly percentages...
Ch. 5 - Corporate triple A bond interest rates for 12...Ch. 5 - The values of Alabama building contracts (in...Ch. 5 - The following time series shows the sales of a...Ch. 5 - Prob. 15PCh. 5 - The following table reports the percentage of...Ch. 5 - Consider the following time series: a. Construct a...Ch. 5 - Consider the following time series:
Construct a...Ch. 5 - The Seneca Children’s Fund (SCF) is a local...Ch. 5 - The president of a small manufacturing firm is...Ch. 5 - Consider the following time series: a. Construct a...Ch. 5 - Consider the following time series...Ch. 5 - The quarterly sales data (number of copies sold)...Ch. 5 - Prob. 25PCh. 5 - South Shore Construction builds permanent docks...Ch. 5 - Hogs & Dawgs is an ice cream parlor on the border...Ch. 5 - Donna Nickles manages a gasoline station on the...Ch. 5 - The Vintage Restaurant, on Captiva Island near...
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
- The table below comes from EPI’s Family Budget Calculator which demonstrates the income a family needs in order to attain a modest yet adequate standard of living. Compared with the federal poverty line and the Supplemental Poverty Measure, EPI’s family budgets provide a more accurate and complete measure of economic security in America. MONTHLY COSTS 2 ADULTS AND 3 CHILDREN CLACKAMAS COUNTY,OR HOUSING $2,017 FOOD $982 CHILD CARE $1,953 TRANSPORTATION $1,282 HEALTH CARE $1,062 OTHER NECESSITIES $1,218 TAXES $2,126 MONTHLY TOTAL $10,632 a.Create a graph that shows this situation clearly.arrow_forwardJensen Tire & Auto is deciding whether to purchase a maintenance contract for its newcomputer wheel alignment and balancing machine. Managers feel that maintenance expenseshould be related to usage, and they collected the following information on weeklyusage (hours) and annual maintenance expense (in hundreds of dollars). a. Develop a scatter chart with weekly usage hours as the independent variable. Whatdoes the scatter chart indicate about the relationship between weekly usage and annualmaintenance expense?b. Use the data to develop an estimated regression equation that could be used to predictthe annual maintenance expense for a given number of hours of weekly usage. Whatis the estimated regression model? c. Test whether each of the regression parameters b0 and b1 is equal to zero at a 0.05level of significance. What are the correct interpretations of the estimated regressionparameters? Are these interpretations reasonable?d. How much of the variation in the sample values of…arrow_forwardUnited Dairies, Inc., supplies milk to several independent grocers throughout Dade County, Florida. Managers at United Dairies want to develop a forecast of the number of half-gallons of milk sold per week. Sales data for the past 12 weeks follow and have been transferred in the data file UDFMilk.xlsx download(also posted under week 11 module). Week Sales Week Sales 1 2750 7 3300 2 3100 8 3100 3 3250 9 2950 4 2800 10 3000 5 2900 11 3200 6 3050 12 3150 By Thursday, April 15 (11:55pm PST), answer the following 2 questions and attach a word doc or excel file to show your work. Use the data in the file UDFMilk.xlsx downloadto construct a time series plot. What type of pattern exists in the data? Use exponential smoothing with to develop a forecast of demand for week 13.arrow_forward
- Please solve all the questions belowarrow_forwardWe have the following data. Using the B&S Model, the price of a call option is ……….. price $100 price $120 Dev 20% 6 months rate 10. Need typed answer only.Please give answer within 45 minarrow_forwardA statistics instructor at a large western university would like to examine the relationship (if any) between the number of optional homework problems students do during the semester and their final course grade. She randomly selects 12 students for study and asks them to keep track of the number of these problems completed during the course of the semester. At the end of the class each student's total marks is recorded along with their final grade. The data follow in Table 2. Table 2 Problem Course Grade 51 62 58 68 62 66 65 66 67 68 76 72 77 73 78 72 78 78 84 73 85 76 91 75 For this setting identify the response variable. i. i. For this setting, identify the predictor variable. Compute the linear correlation coefficient for this data set iv. ii. Classify the direction and strength of the correlation Test the hypothesis for a significant linear correlation, a = 0.05 What is the valid prediction range for this setting? Use the regression equation to predict a student's final course…arrow_forward
- Please answer C. and D. Palisades Eco-Park is a small ecological reserve that admits a relatively small number of visitors on any day, but provides both educational and entertaining lectures, exhibitions, and opportunities to observe nature. The company has collected the following data on labor costs and number of visitors to the park over the last 30 months. Month Labor Cost Visitors 1 $ 25,820 1,700 2 $ 36,290 2,592 3 $ 39,968 2,811 4 $ 31,648 2,222 5 $ 34,809 2,373 6 $ 32,672 2,181 7 $ 32,023 2,205 8 $ 38,334 2,676 9 $ 38,568 2,760 10 $ 46,933 3,572 11 $ 42,157 2,976 12 $ 39,030 2,804 13 $ 34,444 2,415 14 $ 33,173 2,336 15 $ 36,971 2,508 16 $ 26,500 2,099 17 $ 30,663 3,397 18 $ 29,961 2,786 19 $ 27,590 2,412 20 $ 30,003 2,972 21 $ 25,692 2,000 22 $ 24,655 1,794 23 $ 28,892 3,267 24 $ 30,153 3,817 25 $ 28,119 2,592 26 $ 31,690 3,274 27 $ 28,651 2,989 28 $ 29,927 3,050 29 $ 28,438 2,511 30 $ 27,874 2,075…arrow_forwardCompany A, Company B, and Company C sold a number of stocks each month in 2019. Each company described their stock sales in the box plots shown below. Which box plot has the smallest interquartile range?. . 00 Company A Company B then-rany C Company A Company B Company C 500 200 1500 200 2970 TE Number of shocks sold TRON 75 There is not enough information shown in the figures to answer this question.arrow_forwardHow wide is the chasm between what men and women earn in the workplace? According to a 2015 analysis from a national women's group, women lose $435,049 over the course of a career because of the pay gap. The bar graph to the right shows the average earnings in the United States for men and women at ages 22 and 60. This exercise involves the graphs of models for the data shown in the rectangular coordinate system to the right. Complete parts (a) through (c) below. Average Yearly Earnings ($1000s) Average Yearly Earnings in the U.S., by Gender and Age 70- 60- ■Men 50 Women 40- 30- 20- 10- 0- 22 Age 60 Average Yearly Earnings ($1000s) $70- $60- (30,67).. $50 (0,24) $40+ $30+ $20- $10- $0+ 0 M(age=38) = $ thousand (Type an integer or decimal rounded to one decimal place as needed.) ♦ (0,21) Men *(30,40) Women 10 20 30 40 50 Years after Age 22 --X7 (Use integers or decimals for any numbers in the expression. Round to two decimal places as needed.) b. Use the two points for women shown on…arrow_forward
- How wide is the chasm between what men and women earn in the workplace? According to a 2015 analysis from a national women's group, women lose $435,049 over the course of a career because of the pay gap. The bar graph to the right shows the average earnings in the United States for men and women at ages 22 and 55. This exercise involves the graphs of models for the data shown in the rectangular coordinate system to the right. Complete parts (a) through (c) below. BEEB Average Yearly Earnings in the U.S., by Gender and Age M(age=33)=$thousand (Type an integer or decimal rounded to one decimal place as needed.) Average Yearly Earnings ($1000s) 70- 60- Men 50-Women- 40- 30- 20- 10- 0- 22 Age 55 Average Yearly Earnings ($1000s) A $70 (3087) $60- $30 $20- $10- $0 } e $50 (0.23) $40 BN 9 ST (Use integers or decimals for any numbers in the expression. Round to two decimal places as needed.) b. Use the two points for women shown on the graph to find a function in the form W(x) = mx + b that…arrow_forwardSpring is a peak time for selling houses. Suppose the data below contains the selling price, number of bathrooms, square footage, and number of bedrooms of 26 homes sold in Ft. Thomas, Kentucky, in spring 2018. Selling Price Baths Sq Ft Selling Price 160,000 170,000 178,000 182,500 195,100 212,500 245,900 250,000 255,000 258,000 267,000 268,000 275,000 1.5 1,786 2 1,768 1 1,219 1 1,578 1.5 1,125 2 1,196 2 2,128 N W 3 2 1,280 1,596 3.5 2,374 2.5 2,439 2 1,470 2 1,688 Beds 3 3 3 2 3 2 3 3 3 4 3 4 4 295,000 325,000 325,000 328,400 331,000 344,500 365,000 385,000 395,000 399,000 430,000 430,000 454,000 Baths Sq Ft 2.5 1,860 3 2,056 3.5 2,776 2 1,408 1.5 1,972 2.5 1,736 2.5 1,990 2.5 3,640 2.5 1,928 2 2,108 2 2,462 2 2,615 3.5 3,700 Beds 3 4 4 4 3 3 4 4 4 3 4 4 4 Consider the estimated regression equation we developed that can be used to predict the selling price given the number of bathrooms, square footage, and number of bedrooms in the house. (x, denotes number of bathrooms, x₂ denotes…arrow_forwardLovely 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_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
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
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
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Time Series Analysis Theory & Uni-variate Forecasting Techniques; Author: Analytics University;https://www.youtube.com/watch?v=_X5q9FYLGxM;License: Standard YouTube License, CC-BY
Operations management 101: Time-series, forecasting introduction; Author: Brandoz Foltz;https://www.youtube.com/watch?v=EaqZP36ool8;License: Standard YouTube License, CC-BY