What is the equation for the line of best fit

Assignment Help Basic Statistics
Reference no: EM13900815

In this unit we explore how the concept of linear regression is used to model data from a sample. We use MS Excel 2010 to generate a line of best fit, a linear equation that approximates the data values, and then we use the equation to predict other data values.

To complete this discussion, find a YouTube video that gives an example of how a linear equation line of best fit is determined from a data set using Microsoft Excel. Post the video and answer the following questions:

1) What does the data represent?

2) What is the independent variable (x-values)?

3) What is the dependent variable (y-values)?

4) What is the equation for the line of best fit that is determined using the Microsoft Excel Regression Analysis tool on the data?

5) Interpret the coefficients in this equation (the number in front of x, b1, and the constant, bo).

Notes on interpreting the coefficients:

  • The intercept,b0, is the value of y if the value ofxwere 0.
  • The coefficient of the independent variable,b1, is the amount by whichychanges if the value ofxis increased by1.

6) What is the value of R2 ("R-squared" in Excel)? Interpret this.

          Notes on interpreting R2:

  • If R2> 0.90, then the variablexis aVERYGOODpredictor of the variabley. Over 90% of the variance in the value of y can be explained by changes in the value ofx. This equation should be used to predict y-values from x-values.
  • If R2is more than 0.70 but less than 0.90, then the variablexis an acceptable predictor of the variabley. Between 70% and 90% of the variance in the dependent variableycan be explained by changes in the value of the independent variablex. This equation can be used to predict y-values from x-values, with the understanding that some error will exist in predictions.
  • If R2< 0.70, then the variablexis aPOORpredictor of the variabley. This equation should not be used to predict y-values from x-values.

Reference no: EM13900815

Questions Cloud

Explain 4 major advantages of moving : (TCO 9) You have over 10,000 rows of data in an Excel spreadsheet. You have multiple users to input data and run reports. Explain 4 major advantages of moving this data into a database
Next to the following list of eight characteristics : Next to the following list of eight characteristics of business organizations, enter a brief description of how each characteristic applies to general partnerships.
Analytical skills are required in situations : Analytical skills are required in situations where the solution is often clear.Questions that require analytical skills are best avoided in job interviews.Resolving ethical issues often requires analytical skills.Analytical skills are more important ..
Explain how an ectopic pregnancy occurs : What distinguishes a general suffix from other categories of suffixes? Discuss each type of suffix and discuss the rules for the use of combining vowels. When is it necessary to use them?
What is the equation for the line of best fit : What is the independent variable (x-values)? What is the dependent variable (y-values)? What is the equation for the line of best fit that is determined using the Microsoft Excel Regression Analysis tool on the data
Give out estimation results of the final model you chose : Conservation efforts took place only during the last two years in the sample, so if conservation efforts have an effect but with a lag, we'd be forced to use a "one-time dummy".
Advantages of a limited liability corporation : Question 8.8. (TCO 3) Advantages of a Limited Liability Corporation (LLC) include all of the following EXCEPT  unrestricted member participation in management. pass-through taxation benefits of a partnership.
Write a report about how your nationometer works : Write a report about how your Nationometer works and provide a URL link to a working version and understand the different types of dataset you may need to use and how you can gain access to them.
Passage of national environmental policy act : How has passage of the National Environmental Policy Act changed the process by which governmental entities make decisions on public works projects? Give two recommendations for making the NEPA process more effective in attaining its objectives?

Reviews

Write a Review

Basic Statistics Questions & Answers

  Automobile production-table-graph and modeling

The table shows the retail market share of passenger cars from Ford Motor Company as a percent of the US market.

  Normal distribution throughout the year

The price of XYZ Corporation stock is normally distributed all through the year with mean of $42.00 per share and a standard deviation of $2.25 per share. Suppose that the stock is traded 240 days out of the year.

  How large a sample is necessary for confident of results

A recent poll of 700 people who work indoors found that 278 smoke. If the researchers want to be 98% confident of their results to within 3.5 percentage points, how large a sample is necessary?

  Compute the hazard rate function of x when x is uniformly

compute the hazard rate function of x when x is uniformly distributed over 0

  Using the cv compare the variability of the two items

using the cv compare the variability of the two items. suggest reasons for any differencescv of item nr 1cv 0.01837cv

  Sampling distribution and the central limit theorem

The Central Limit Theorem states that the sampling distribution of means is:

  Suppose an unfair coin comes up heads 368 of the time if

suppose an unfair coin comes up heads 36.8 of the time if it is flipped. if the coin is flipped 11 times what is the

  Why might a driver be tempted not to use a seat belt

A certain airplane has two independent alternators to provide electrical power. The probability that a given alternator will fail on a 1-hour flight is .02. What is the probability that (a) both will fail? (b) Neither will fail? (2) One or the other ..

  Prepare a confidence interval for the true proportion

Prepare a 90% confidence interval for the true proportion

  Pearsons correlation coefficient

Does the weight of a vehicle affect the gas mileage? The following random sample was collected where  x  = weight of a vehicle in hundreds of pounds and  y  = miles per gallon.

  What is the probability that there will be a least one

if a couple plans to have 10 children what is the probability that there will be a least one girl? if the couple

  What is the probability that 5 of the people there are

at parkview at any given time the probability that a randomly selected student is a female is 30.with this binomial

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