Everest University Tampa AT&T Mobile Phone Service Revenue by Quarter Worksheet
Question Description
a)– In this section, you have to write and solve statistical problems that could be of interest to the company you select. You are to make-up the data (do not use any data found online). The company is AT&T
Problem: Regression Analysis
➢ Select a dependent variable that your company may wish to forecast.
➢ Select an independent variable that to forecast your selected dependent variable.
➢ Construct a data file with at least 25 observations to predict your dependent variable for your company (such as, the number of units of a particular item sold weekly) based on your independent variable (such as, the price of the product).
➢ Use Data Analysis in Excel (not PHStat) to find the least-squares line;
➢ Test if your independent variable is a significant variable to forecast your dependent variable. Show all steps.
➢ Forecast your dependent variable for a value within the relevant range. Is your forecast meaningful? Explain.
➢ What is the value of the coefficient of determination? Give interpretation. Is your interpretation meaningful? Explain.
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."