South 5 hore Construction builds permanent docks and seavalls along the southern shore of long isiand, new york. Although the firm has been in business for only five years, revence has increased from $328,000 in the first year of operation to $1,104,000 in the most recent year. The following data show the quarterly sales revenue in thousands of dollars: a. Choose the correct time serios plot: 2 more Check Ay Work uses remaining b. Use Excel Solver to find the coefficients of a multiple regression model with dummy variabies as follows to develop an equation to account for seasonal effects in the data, Qtr 1=1 if Quarter 1,0 otherwise; Qtr2 = 1 if Quarter 2,0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. Round your answers to two decimal places. Fi=+Qtr1+Qtr2+QQ c. Lek Period =1 to refer to the observation in Quarter 1 of year 1 ; Period =2 to refor to the observation in Quarter 2 of year 1 ; . . . and Period =20 to refer to the observation in Quarter 4 of year 5 . Using the dummy variables defined in part (b) and Period, deveiop on equation to account for seasonal effects and any linear trend in the time series uging Excel Solver. Round your answers to two decimal places. If your answer is negative value enter minus sign. Fr=Qtr1+Qtr2+Qtr3+Period Based upon the seasonal effects in the data and linear trend, compute estimates of quarterly sales for year 6. Round your answers to one decimal place. Quarter 1 forecast = Quarter 2 forecast = Quarter ] forecast = Quartar 4 forecast = The Centers for disease Control and Prevention Office on Smoking and Health (OSH) is the lead federal agency responsible for comprehensive tobacco prevention and control. OSH was established in 1965 to reduce the death and disease caused by tobacco use and exposure to second-hand smoke. One of the many responsibilities of the OSH is to collect data on tobacco use. The following data show the percentage of adults in the United States who were users of tobacco from 2001 through 2011 (http://www.cdc.gov/tobacco/data statistics/tables/trends/cig smoking/index.htm). a. Choose the correct time series plot. a. Choose the correct time series plot. What type of pattern exists in the data? b. Use simple linear regression to find the parameters for the line that minimizes MSE for this time series. ( t=1 for 2001 year, t= 2 for 2002 year, ..., and t=11 for 2011 year.) Round your answers to four decimal places. Use minus sign for negative values. Tt= c. One of OSH's Healthy People 2020 Goals is to cut the percentage of adults in the United States who were users of tobacco to 12% or less by the year 2020 . Does your regression model from part (b) suggest that the OSH is on target to meet this goal? South 5 hore Construction builds permanent docks and seavalls along the southern shore of long isiand, new york. Although the firm has been in business for only five years, revence has increased from $328,000 in the first year of operation to $1,104,000 in the most recent year. The following data show the quarterly sales revenue in thousands of dollars: a. Choose the correct time serios plot: 2 more Check Ay Work uses remaining b. Use Excel Solver to find the coefficients of a multiple regression model with dummy variabies as follows to develop an equation to account for seasonal effects in the data, Qtr 1=1 if Quarter 1,0 otherwise; Qtr2 = 1 if Quarter 2,0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. Round your answers to two decimal places. Fi=+Qtr1+Qtr2+QQ c. Lek Period =1 to refer to the observation in Quarter 1 of year 1 ; Period =2 to refor to the observation in Quarter 2 of year 1 ; . . . and Period =20 to refer to the observation in Quarter 4 of year 5 . Using the dummy variables defined in part (b) and Period, deveiop on equation to account for seasonal effects and any linear trend in the time series uging Excel Solver. Round your answers to two decimal places. If your answer is negative value enter minus sign. Fr=Qtr1+Qtr2+Qtr3+Period Based upon the seasonal effects in the data and linear trend, compute estimates of quarterly sales for year 6. Round your answers to one decimal place. Quarter 1 forecast = Quarter 2 forecast = Quarter ] forecast = Quartar 4 forecast = The Centers for disease Control and Prevention Office on Smoking and Health (OSH) is the lead federal agency responsible for comprehensive tobacco prevention and control. OSH was established in 1965 to reduce the death and disease caused by tobacco use and exposure to second-hand smoke. One of the many responsibilities of the OSH is to collect data on tobacco use. The following data show the percentage of adults in the United States who were users of tobacco from 2001 through 2011 (http://www.cdc.gov/tobacco/data statistics/tables/trends/cig smoking/index.htm). a. Choose the correct time series plot. a. Choose the correct time series plot. What type of pattern exists in the data? b. Use simple linear regression to find the parameters for the line that minimizes MSE for this time series. ( t=1 for 2001 year, t= 2 for 2002 year, ..., and t=11 for 2011 year.) Round your answers to four decimal places. Use minus sign for negative values. Tt= c. One of OSH's Healthy People 2020 Goals is to cut the percentage of adults in the United States who were users of tobacco to 12% or less by the year 2020 . Does your regression model from part (b) suggest that the OSH is on target to meet this goal