Practice More Quizzes:

## Q:

### Add a trendline to the plot. Which of the following seems to be the best trendline option?

## Q:

### Forecast food retailing for every month of 2021 using a simple linear regression with an intercept, and time as the explanatory variable. Use the Regression tool in the Analysis Toolpak, and include the generation of residuals. Once you perform this regression, answer the following questions: In this regression, what is the dependent variable?

## Q:

### In this regression, what is the explanatory variable?

## Q:

### Once the regression is performed Observations should be equal to:

## Q:

### From the regression output, what is the coefficient of Time (rounded to 2 decimal places)?

## Q:

### From the regression output, what is the value of the Intercept (rounded to 2 decimal places)?

## Q:

### How would you describe what the value of the Intercept represents?

## Q:

### From the regression output, what is the p-value of the coefficient of Time (rounded to 2 decimal places)?

## Q:

### In the regression output, what does the p-value of the coefficient of Time tell us?

## Q:

### In the regression output, what does 8.2382E-212 tell us? If you do not see this figure in your regression output, you should re-do your regression.

## Q:

### From the regression output, what is the t-statistic of the coefficient of Time (rounded to 2 decimal places)?

## Q:

### In the regression output, how is the t-statistic of Time calculated?

## Q:

### From the regression output, what is the value of R Square (rounded to 3 decimal places)?

## Q:

### From the regression output, what is within-sample forecast for December 2020 (rounded to 2 decimal places)?

## Q:

### Using the regression output, forecast turnover values for 2021. What is the out-of-sample forecast for January 2021 (rounded to 2 decimal places)?

## Q:

### What is the out-of-sample forecast for December 2021 (rounded to 2 decimal places)?

## Q:

### What is the standard error of the regression (rounded to 2 decimal places)?

## Q:

### Based on your above answers, why might this be an appropriate model for business forecasting?

Subscribe

0 Comments

Find Questions in This Page: "

**"***CTRL+F*