Please do all of these problems in EXCEL and upload the spreadsheets to this assignment. 1. Consider the time series data given below: Xi 8 3 2 10 11 3 6 5 6 8 yi 4 12 1 14 12 9 4 9 6 1 Use the least square method to determine the equation of line of best fit for the data. 2. Number of man-hours and the corresponding productivity (in units) are furnished below. Fit a simple linear regression equation ^Y = a + bx applying the method of least squares. 3. The sales of a company (in million dollars) for each year are shown in the table below. x (year) 2005 2006 2007 2008 2009 y (sales) 12 19 29 37 45 a) Find the least square regression line y = ax + b. b) Use the least squares regression line as a model to estimate the sales of the company in 2012.

Please do all of these problems in EXCEL and upload the spreadsheets to this assignment. 1. Consider the time series data given below: Xi 8 3 2 10 11 3 6 5 6 8 yi 4 12 1 14 12 9 4 9 6 1 Use the least square method to determine the equation of line of best fit for the data. 2. Number of man-hours and the corresponding productivity (in units) are furnished below. Fit a simple linear regression equation ^Y = a + bx applying the method of least squares. 3. The sales of a company (in million dollars) for each year are shown in the table below. x (year) 2005 2006 2007 2008 2009 y (sales) 12 19 29 37 45 a) Find the least square regression line y = ax + b. b) Use the least squares regression line as a model to estimate the sales of the company in 2012.

College Algebra

1st Edition

ISBN:9781938168383

Author:Jay Abramson

Publisher:Jay Abramson

Chapter6: Exponential And Logarithmic Functions

Section6.8: Fitting Exponential Models To Data

Problem 3TI: Table 6 shows the population, in thousands, of harbor seals in the Wadden Sea over the years 1997 to...

See similar textbooks

Similar questions

Table 2 shows a recent graduate’s credit card balance each month after graduation. a. Use exponential regression to fit a model to these data. b. If spending continues at this rate, what will the graduate’s credit card debt be one year after graduating?
Olympic Pole Vault The graph in Figure 7 indicates that in recent years the winning Olympic men’s pole vault height has fallen below the value predicted by the regression line in Example 2. This might have occurred because when the pole vault was a new event there was much room for improvement in vaulters’ performances, whereas now even the best training can produce only incremental advances. Let’s see whether concentrating on more recent results gives a better predictor of future records. (a) Use the data in Table 2 (page 176) to complete the table of winning pole vault heights shown in the margin. (Note that we are using x=0 to correspond to the year 1972, where this restricted data set begins.) (b) Find the regression line for the data in part ‚(a). (c) Plot the data and the regression line on the same axes. Does the regression line seem to provide a good model for the data? (d) What does the regression line predict as the winning pole vault height for the 2012 Olympics? Compare this predicted value to the actual 2012 winning height of 5.97 m, as described on page 177. Has this new regression line provided a better prediction than the line in Example 2?
Table 6 shows the population, in thousands, of harbor seals in the Wadden Sea over the years 1997 to 2012. a. Let x represent time in years starting with x=0 for the year 1997. Let y represent the number of seals in thousands. Use logistic regression to fit a model to these data. b. Use the model to predict the seal population for the year 2020. c. To the nearest whole number, what is the limiting value of this model?
What does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?
Find the mean hourly cost when the cell phone described above is used for 240 minutes.
If you travel 100 miles in two hours, then your average speed for the trip is Average speed=_________=________
Question is in the photo attached.
if an estimated regression line has a y-intercept of 10 and a slope of -4, then when x=2, what is the predicted value of y?
Can youm please assist with a,b and c. Please do it clear enough so i can understand. Thanks
please only answer the last part "Suppose that real income per capita in New Jersey increases by 1% in the next year. Use the results in column (4) to predict the change in the number of traffic fatalities in the next year. "
If an estimated regression line has a y-intercept of 10 and a slope of -4, then when x= 2, the predicted value of y is?
A 10-year study conducted by the American Heart Association provided data on how age, blood pressure, and smoking related to the risk of strokes. The data file “Stroke.xslx” includes a portion of the data from the study. The variable “Risk of Stroke” is measured as the percentage of risk (proportion times 100) that a person will have a stroke over the next 10-year period. Regression Analysis As Image: 1) Based on the simple regression analysis output, write the estimated regression equation. 2) What is the correlation coefficient between Risk of Stroke and Age? How do you find i