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

Can someone who knows how to use excel run a linear trend line
off of this data and give me the linear trend equation that comes
out of the data? Please post the graph with the linear trend and
the equation which is y=?x+?
Quarter
X
Y = ( Exchange Rate)
Y4Q1
1
5.60
Y4Q2
2
6.32
Y4Q3
3
6.23
Y4Q4
4
6.03
Y5Q1
5
6.16
Y5Q2
6
5.68
Y5Q3
7
5.53
Y5Q4
8
5.63
Y6Q1
9
5.62
Y6Q2
10...

Bivariate Data & Probability
After completing the calculation by hand in Q1 you can use
Excel to check your answers before submitting. Q2 assesses your
general understanding of probability and linear associations using
Excel to analyse a large dataset.
Question 1
Covariance and Correlation
The table below shows a set of sample bivariate data. Calculate
the covariance and correlation coefficient by completing the below
table. Show all working.
X
Y
(X - )
(Y - )
(X - )(Y -...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 14 minutes ago

asked 19 minutes ago

asked 22 minutes ago

asked 26 minutes ago

asked 30 minutes ago

asked 48 minutes ago

asked 53 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago