Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 8, 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
The monthly cost for health care for an employee and two dependents in a certain year is given in the following table.
Provider
Cost
Provider
Cost
Maxicare
$415.31
Kaiser
$4337
Cigna
$424.74
Aetna
$436.26
Health Net
$427.29
Blue Shield
$442.25
Pacific Care
$428.06
Omni Healthcare
$457.90
Redwoods Plan
$431.53
Lifeguard
$457.64
Draw a box plot for the monthly costs of health care (ranked from lowest to highest).
0415
420
425
430
435
440
0425
430
435
440
445
450
455
420
430
440
450
420
430
440
450
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.
When 20 employees were first hired in 2011 for a creative engineering firm, Company A, the starting annual salary was $35,000. A competing creative engineering firm, Company B, had the same starting salary for 20 employees hired the same year. In 2016, data was collected on the annual salaries of the same employees at each of the two companyies. This data is displayed in the box plot shown. Part A: Compare the annual salary distributions and what are the pros and cons of working at each company? Explain using what you found in Part A
Chapter 8 Solutions
Essentials of Business Analytics (MindTap Course List)
Ch. 8 - Consider the following time series data:
Using...Ch. 8 - Refer to the time series data in Problem 1. Using...Ch. 8 - Problems 1 and 2 used different forecasting...Ch. 8 - Consider the following time series data:
Compute...Ch. 8 - Consider the following time series...Ch. 8 - Consider the following time series...Ch. 8 - Refer to the gasoline sales time series data in...Ch. 8 - Prob. 8PCh. 8 - Prob. 9PCh. 8 - Prob. 10P
Ch. 8 - For the Hawkins Company, the monthly percentages...Ch. 8 - Corporate triple A bond interest rates for 12...Ch. 8 - The values of Alabama building contracts (in...Ch. 8 - The following time series shows the sales of a...Ch. 8 - Prob. 15PCh. 8 - The following table reports the percentage of...Ch. 8 - Consider the following time series: a. Construct a...Ch. 8 - Consider the following time series:
Construct a...Ch. 8 - Because of high tuition costs at state and private...Ch. 8 - The Seneca Children’s Fund (SCF) is a local...Ch. 8 - The president of a small manufacturing firm is...Ch. 8 - Consider the following time series: a. Construct a...Ch. 8 - Consider the following time series...Ch. 8 - The quarterly sales data (number of copies sold)...Ch. 8 - Prob. 25PCh. 8 - South Shore Construction builds permanent docks...Ch. 8 - Hogs & Dawgs is an ice cream parlor on the border...Ch. 8 - Donna Nickles manages a gasoline station on the...Ch. 8 - 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
- Company 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_forwardPaddy has lots of cousins. With a family reunion in the near future, Paddy decides to collect income information for himself and all his cousins. He obtains the following data points: Incomes:$52,000$22,000$92,000$8,000$118,000$62,000$38,000$14,000$132,000$46,000$26,000$96,000$54,000$110,000$80,000 What is the percentage of income received by the third quintile of the income distribution of Paddy's cousins? Round your answer to the nearest tenth.arrow_forwardIn retail, a store manager uses time series models to understand shopping trends. Review the scatter plot of the store’s sales from 2010 through 2021 to answer the questions. See attached as image. Here is the data for Fiscal Year and Sales: Fiscal Year Sales 2010 $260,123.00 2011 $256,853.00 2012 $274,366.00 2013 $290,525.00 2014 $322,318.00 2015 $380,921.00 2016 $541,925.00 2017 $909,050.00 2018 $1,817,521.00 2019 $3,206,564.00 2020 $4,921,005.00 2021 $5,686,338.00 Time series decomposition seeks to separate the time series (Y) into 4 components: trend (T), cycle (C), seasonal (S), and irregular (I). What is the difference between these components? The model can be additive or multiplicative. When do you use each? Review the scatter plot of the exponential trend of the time series data. Do you observe a trend? If so, what type of trend do you observe? What predictions might you make about the store’s annual sales over the next few years?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 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_forwardWhen 20 employees were first hired in 2011 for a creative engineering firm, Company A, the starting annual salary was $35,000. A competing creative engineering firm, Company B, had the same starting salary for 20 employees hired the same year. In 2016, data was collected on the annual salaries of the same employees at each of the two companyies. This data is displayed in the box plot shown. Part A: what are the pros and cons of working at each company? Explain using what you found in Part Aarrow_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 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_forward
- The United Nations Human Development Report gives the following data for real GDP per person in 2018: China, $15,270; Russia, $24,233; Canada, $43,433; United States, $54,941. Life expectancy at birth is 79.3 in Canada, 78.8 in the United States, 76.6 in China, and 72.3 in Russia. Freedom House rates political freedom each year, and its ratings are as follows: Canada, 1.0; the United States, 1.5; Russia, 6.5; and China, 6.5 ((1.0 is the most free and 7.0 is the least free). How do life expectancy at birth and political freedom change the relative ranking of living standards that real GDP per person indicate? A. They don't change the relative ranking because they rank countries in a similar way as real GDP per person ranks them. B. They completely reverse the relative ranking because they rank countries exactly opposite to the way that real GDP per person ranks them. C. They don't change the relative ranking of Canada and the United…arrow_forwardPart 2: The owner of a pet store is trying to decide whether to discontinue selling specialty clothes for pets. She suspects that only 4% of the customers buy specialty clothes for their pets and thinks that she might be able to replace the clothes with more interesting and profitable items on the shelves. Before making a final decision she decides to keep track of the total number of customers for a day, and whether they purchase specialty clothes for their pet. Assuming the pet store owner is correct in thinking that only 4% of her customers purchase specialty clothes for their pets, how many customers should she expect before someone buys a garment for their pet? l. 2. What is the probability that she does not sell a gament until the 7th customer? Show work. What is the probability that exactly 3 of the first 10 customers buy specialty clothes for their pet? Show work. 4. What is the probability that at least 3 of the first 40 customers buy specialty clothes for their pet? Show…arrow_forwardUnit 5 Lab Background: Between the years of 1997 and 2003, the World Health Organization collected data on head circumference, arm circumference, and other body measurements for 8440 children from Brazil, Ghana, India, Norway, Oman and the USA. All of the children were healthy and breastfed by mothers who did not smoke. Children in the sample lived in socioeconomic conditions favorable to normal physical growth. Variables such as parental education level and income level were used to exclude children whose growth was “environmentally constrained”; however, low-weight full term babies were included if their mothers met socioeconomic and nutritional criteria. In short, the study design attempted to include healthy children from a wide range of ethnic and cultural groups whose home environments reasonably assured the conditions for healthy physical growth. This data was used to produce growth charts that are part of every pediatrician’s toolkit for monitoring a child’s overall…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_forwardAccording to Zillow.com, the median sale price for homes in January for South Carolina, California, and Virginia over the last three years is given in the table below (measured in $100,000). able South Carolina California Virginia 2018 183 534 98 2019 193 555 94 2020 216 569 85 In South Carolina, realtors take 5.4% of the sale price on average as part of their commission. The average realtor commission rates in California and Virginia are 4.9% and 5.3%, respectively. Use matrix multiplication to find the total earned by realtors from their commissionsarrow_forwardGovernment economic studies reveal that young adults, not middle-aged or older adults, are having the most difficult time in today’s economy. Although the nation’s labor market shows a decline in the unemployment rate, the percentage of young adults, ages 18 to 24, currently employed (54 percent) is at the lowest level since the government data collection began in 1948. If you were working for a national survey organization doing a general public survey of young adults and older adults, what topics and questions would you design into your survey to elaborate on this finding?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