# UOP QRB 501 Week 3 Exercise 1

## UOP QRB 501 Week 3 Exercise 1

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.
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.
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.
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.
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.