UOP QRB 501 Week 3 Exercise 1
Month Earnings
1 13
2 18
3 25
4 34
5 45
6 58
7 73
8 90
9 109
10 130
Use Excel to do the following:
Create a vertical bar chart, label the axes and add a chart title.
Add the trend line.
Right-click on a bar
Select Polynomial and Order 2
Check "Display Equation on chart"
Right down the equation of the trend line.
Calculate the forecast for the earnings in month 12.
Attach your Excel file to this thread.
To purchase this material click on the link
http://www.assignmentcloud.com/QRB-501-NEW/QRB-501-Week-3-Exercise-1
For more details visit
www.assignmentcloud.com
UOP QRB 501 Week 3 Exercise 1
Month Earnings
1 13
2 18
3 25
4 34
5 45
6 58
7 73
8 90
9 109
10 130
Use Excel to do the following:
Create a vertical bar chart, label the axes and add a chart title.
Add the trend line.
Right-click on a bar
Select Polynomial and Order 2
Check "Display Equation on chart"
Right down the equation of the trend line.
Calculate the forecast for the earnings in month 12.
Attach your Excel file to this thread.
To purchase this material click on the link
http://www.assignmentcloud.com/QRB-501-NEW/QRB-501-Week-3-Exercise-1
For more details visit
www.assignmentcloud.com
UOP QRB 501 Week 3 Exercise 1
Month Earnings
1 13
2 18
3 25
4 34
5 45
6 58
7 73
8 90
9 109
10 130
Use Excel to do the following:
Create a vertical bar chart, label the axes and add a chart title.
Add the trend line.
Right-click on a bar
Select Polynomial and Order 2
Check "Display Equation on chart"
Right down the equation of the trend line.
Calculate the forecast for the...