Determine the regression equation, Applied Statistics

Assignment Help:

The file Midterm  Data.xls has a tab labeled "National Grid vs. Alcoa" which presents historical price data for two stocks.  Using the National Grid price as the X-value and the Alcoa price as the Y-value, we will perform a long-form regression analysis on this data.

            •  Compute the values of, , SSXX, SSYY, SSXY.

            •  Determine the regression equation.

            •  Compute the standard error of the estimate se.

            •  Determine 95% confidence interval for the price of Alcoa, , when the price of National Grid is at 60.


Related Discussions:- Determine the regression equation

Circul;atory ststistics Lab, What statistics can be obtained from a circula...

What statistics can be obtained from a circulatory lab?

Calculate total surplus, When the number of farmers growing wheat in Russia...

When the number of farmers growing wheat in Russia increases, the increase in world supply lowers the world price of wheat. Draw an appropriate diagram to analyze how this chang

Coefficient of variation, Coefficient of Variation or C.V. To compare t...

Coefficient of Variation or C.V. To compare the variability between or more series, coeffiecnt of variation is used, it is relative measure of dispersion, it innovated and used

Determine best estimates of the population mean and variance, Question: ...

Question: (a) A normal distribution is thought to have a mean of 50. A random sample of 100 gave a mean of 52.6 and a standard deviation of 14.5. A significance test was carri

Melissa Bakery, Melissa Bakery is preparing for the coming thanksgiving fes...

Melissa Bakery is preparing for the coming thanksgiving festival. The bakery plans to bake and sell its favourite cookies; butter cookies, chocolate cookies and almond cookies. A k

Normal probability plots, The Null Hypothesis - H0:  The random errors will...

The Null Hypothesis - H0:  The random errors will be normally distributed The Alternative Hypothesis - H1:  The random errors are not normally distributed Reject H0: when P-v

Simple regression analysis, Construct your initial multivariate model by se...

Construct your initial multivariate model by selecting a dependent variable Y and two independent variables X. Clearly define what each variable represents and how this relates t

Estimate the values of the dependent variable, 1. Suppose you are estimatin...

1. Suppose you are estimating the imports (from both the U.S. mainland and foreign countries) of fuels and petroleum products in Hawaii (the dependent variable). The values of the

Data project, Dr. Jim Mirabella UNIT EIGHT: DATA ANALYSIS PROJECT All Excel...

Dr. Jim Mirabella UNIT EIGHT: DATA ANALYSIS PROJECT All Excel output should be copied into a single Word document where you must enter all of your responses to the questions below.

Statistical definition of probability, Statistical Definition of probabilit...

Statistical Definition of probability: Ques: (a) (i)  Distinguish Statistical Definition of probability from the Classical Definition.                  (ii) State the A

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd