Question

Can someone who knows how to use excel forecast my data and give me exhange rates for Y6Q1, Y6Q2, Y6Q3, and Y6Q4? Also, once the results are added for year 6, can I have a scatter plot with the line going across be done with all the information provided with the information given?

Quarter X    Y=Exchange Rate

Y3Q1    1 6.07

Y3Q2    2 6.30

Y3Q3    3 5.73

Y3Q4    4 5.57

Y4Q1    5 5.60

Y4Q2    6 6.32

Y4Q3    7 6.23

Y4Q4    8 6.03

Y5Q1    9 6.16

Y5Q2 10    5.68

Y5Q3 11    5.53

Y5Q4 12    5.63

Y6Q1 13 ?

Y6Q2 14 ?

Y6Q3 15 ?

Y6Q4 16 ?

Answer 1

We need to run linear regression in excel:

The steps of it as follows :

Step 1) First enter the given data set in excel columns.

Step 2) Then click on Data >>> Data Analysis >>>Regression >>>>OK

Step 3) Input Y Range: Select the data of column "Y"

Input X Range: Select Column X

Click on Lable

then Click on Ouput Range

Look the following Image

Then Click on OK, we get following result.

From the above output the linear regression equation is given by

y = 6.0853 - 0.02787 * x

Let's pluf x = 13, 14, 15, and 16 we get the corresponding predicted values as