The following are sales revenues for a large utility company for years 1 through 11. Forecast revenue for years 12 through 15. Because we are forecasting four years into the future, you will need to use linear regression as your forecasting method. (Enter your answers in millions.) YEAR REVENUE (MILLIONS) 1 $ 4,866.2 2 5,075.6 3 5,518.5 4 5,719.4 5 5,495.4 6 5,198.0 7 $ 5,091.9 8 5,105.8 9 5,551.2 10 5,738.9 11 5,868.2 Period Forecast 12 13 14 15

The following are sales revenues for a large utility company for years 1 through 11. Forecast revenue for years 12 through 15. Because we are forecasting four years into the future, you will need to use linear regression as your forecasting method. (Enter your answers in millions.) YEAR REVENUE (MILLIONS) 1 $ 4,866.2 2 5,075.6 3 5,518.5 4 5,719.4 5 5,495.4 6 5,198.0 7 $ 5,091.9 8 5,105.8 9 5,551.2 10 5,738.9 11 5,868.2 Period Forecast 12 13 14 15

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter4: Equations Of Linear Functions

Section4.6: Regression And Median-fit Lines

Problem 17HP

See similar textbooks

Similar questions

Demand for Candy Bars In this problem you will determine a linear demand equation that describes the demand for candy bars in your class. Survey your classmates to determine what price they would be willing to pay for a candy bar. Your survey form might look like the sample to the left. a Make a table of the number of respondents who answered yes at each price level. b Make a scatter plot of your data. c Find and graph the regression line y=mp+b, which gives the number of respondents y who would buy a candy bar if the price were p cents. This is the demand equation. Why is the slope m negative? d What is the p-intercept of the demand equation? What does this intercept tell you about pricing candy bars? Would you buy a candy bar from the vending machine in the hallway if the price is as indicated. Price Yes or No 50 75 1.00 1.25 1.50 1.75 2.00
Life Expectancy The following table shows the average life expectancy, in years, of a child born in the given year42 Life expectancy 2005 77.6 2007 78.1 2009 78.5 2011 78.7 2013 78.8 a. Find the equation of the regression line, and explain the meaning of its slope. b. Plot the data points and the regression line. c. Explain in practical terms the meaning of the slope of the regression line. d. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 2019? e. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 1580?2300
Mortgage Rates The following table is taken from the website of Freddie Mac. It shows rates for 30-year fixed-rate mortgages since 1970. y=Year r=Mortgagerate 1975 9.05 1980 13.74 1985 12.43 1990 10.13 1995 7.93 2000 8.05 2005 5.87 2010 4.69 2015 3.84 a. Explain in practical terms the meaning of r(2003). b. Use the table to estimate the value of r(2003).
Table 6 shows the year and the number ofpeople unemployed in a particular city for several years. Determine whether the trend appears linear. If so, and assuming the trend continues, in what year will the number of unemployed reach 5 people?
The following table shows the reported net sales by Nokia in 2008, 2009, and 2010. Year 2008 2009 2010x 0 1 2Sales ($ millions) 20 50 60 Find the Equation of the Linear Regression Line. Rounds decimal values to the nearest tenths.
Please answer the first two subparts only. Part (C) (c) Use the regression equation to make a prediction for each quarter in 2011. (Enter your answers in millions rounded to 3 decimal places.) Quarter Predicted Q1 Q2 Q3 Q4 Quarterly Revenue for Coca Cola Company, 2005-2010 (millions of dollars) Quarterly Revenue for Coca Cola Company, 2005-2010 (millions of dollars) Year Quarter Revenue 2005 Qtr1 5,206 In row-column format Qtr2 6,310 Quarter 2005 2006 2007 2008 2009 2010 Qtr3 6,037 Qtr1 5,206 5,226 6,103 7,379 7,169 7,525 Qtr4 5,551 Qtr2 6,310 6,476 7,733 9,046 8,267 8,674 2006 Qtr1 5,226 Qtr3 6,037 6,454 7,690 8,393 8,044 8,426 Qtr2 6,476 Qtr4…
The managing director of a consulting group has the accompanying monthly data on total overhead costs and professional labor hours to bill to clients. Complete parts a through c. E Click the icon to view the monthly data. a. Develop a simple linear regression model between billable hours and overhead costs. Overhead Costs = 5304.4 + (0.0219) × Billable Hours +1 (Round the constant to one decimal place as needed. Round the coefficient to four decimal places as needed. Do not include the $ symbol in your answers.) Monthly overhead costs and billable hours data Overhead Costs Billable Hours O IT $385,000 3,000 $430,000 4,000 $460,000 5,000 $511,000 6,000 $580,000 7,000 $600,000 8,000 Print Done
The number of Master’s degrees granted at a particular university is given for selected years in the table below. Year 2005 2010 2015 2020 Number of Master’s Degrees 58 69 76 83 Use the linear regression equation for this data to predict the number of Master’s degrees that this university will grant in the year 2021. Blank 1. Calculate the answer by read surrounding text. Round to the nearest whole number of Master's degrees.
(please solve within 15 minutes I will give thumbs up)
Dr. Lillian Fok, a New Orleans psychologist, specializes in treating patients who are agoraphobic (i.e., afraid to leave their homes). The following table indicates how many patients Dr. Fok has seen each year for the past 10 years. It also indicates what the robbery rate was in New Orleans during the same year. Year Number of Patients Robbery Rate per 1,000 Population The simple linear regression equation that shows the best relationship between the number of patients and the robbery rate is (round your responses to three decimal places) where y Number of Patients and x = Robbery Rate. = 1 2 3 4 6 7 36 33 40 41 55 60 58.3 61.1 73.4 75.7 81.1 89.0 101.1 5 40 8 54 94.8 9 58 103.3 10 61 116.2
The managing director of a consulting group has the accompanying monthly data on total overhead costs and professional labor hours to bill to clients. Complete parts a through o. Click the icon to view the monthly data. a. Develop a simple linear regression model between billable hours and overhead costs. Overhead Costs OxBillable Hours (Round the constant to one decimal place as needed. Round the coefficient to four decimal places as needed. Do not include the $ symbol in your answers.) Monthly Overhead Costs and Billable Hours Data Overhead Costs $385,000 Billable Hours 3,000 $425,000 4,000 $445.000 5,000 $497,000 6,000 $570,000 7,000 $590,000 8,000
The following are sales revenues for a large utility company for years 1 through 11. Forecast revenue for years 12 through 15. Because we are forecasting four years into the future, you will need to use linear regression as your forecasting method. (Enter your answers in millions.) REVENUE (MILLIONS) $4,874.9 5,060.2 YEAR 1 2 3 5,515.5 5,738.5 5,503.3 5,188.6 $5,091.0 5,118.4 5,555.1 5,734.0 5,863.4 4 7 8 9 10 11 Period Forecast 12 13 14 15