American Public University Linear Regression Equation and Analysis Homework Calculate a dependent variable projection using Excel to calculate simple regre

American Public University Linear Regression Equation and Analysis Homework Calculate a dependent variable projection using Excel to calculate simple regression analysis.

Use the information at the URL listed below to create an Excel spreadsheet that solves a linear forecast equation, using Excel’s regression tool. Use the Excel Forecasting tools to create projected revenue and profit, based on historical data. You create a spreadsheet with x and y variables in columns and then create a graph. On the graph, use the chart feature and follow instructions at the website. Create three projected future values for the dependent variable. After completing the Excel spreadsheet, discuss the following in the forum:

In what ways can the Excel forecast tool help determine future base values from knowing the relationship between past values. The table below is an example. If you want to on your own, use the Excel forecast to predict future periods, using the same technique as the example at the URL.

http://blog.trap.it/blog/stats-for-marketers-a-sim…

Below you have been given some data over time; conduct a simple regression analysis of the data over time. What is the trend or message that this data is telling you? What might be missing from this data?

Discuss the function of the following statistical terms. Why are they important?

Line of best fit

R2 value

Slope

The following can be used to practice the Excel Regression if you like.

Pool

Base

Our review Determined

2011

3,000,000

1,500,000

2012

3,200,000

2,000,000

2013

3,300,000

2,200,000

2014

3,600,000

2,500,000

2015

3,400,000

2,300,000

Proposed

3,000,000

2,400,000

2,600,000

Instructions: Initial post should be at least 300 words.

Reading:

George, G., Haas, M. R., & Pentland, A. (2014). Big data and management Academy of Management Journal, 57, 321-326. doi:10.5465/amj.2014.4002

Singh, H., & Singh, G. (2017). Big data-A review. I-Manager’s Journal on Information Technology, 6(1), 25-35. Retrieved from https://search-proquest-com.ezproxy2.apus.edu/docview/1920564759?accountid=8289