# INSTRUCTIONS: Provide (2) peer responses for RESPONSES 1 AND 2

INSTRUCTIONS: Provide (2) peer responses for RESPONSES 1 AND 2 below. Attached are RESPONSE 1 and 2 excel work to help you with the responses.

Peer response #1 – Looking at your peer’s Excel output, and the Regression Equation they wrote out, interpret the slope of their Regression Equation. Use their Regression Equation to make a prediction and show the work for your predicted value based on your expression. For Example, if your peer used Year to predict Price, plug in a Year value into the regression equation and use it to predict the Price of a vehicle. Does this predicted Price value make sense with their data?

Peer response #2 – It is important to remember that typically a two-factor regression model cannot accurately describe the entire situation. Look at the dependent variable that your peer chose. Name at least 2 independent factors you would use to run a Multiple Linear Regression (MLR) and explain why you feel they are related. Then use those factors to run a Multiple Linear Regression (MLR) on your peer’s data and see if the variables you chose are related to the dependent variable they chose. What is your MLR equation? Is your MLR significant? Are any of the Independent factors significant? What is the R2 value? Explain and interpret this value and how it relates to the MLR. Make sure you include your MLR Excel output as an attachment in your response post.

RESPONSE 1:

For this weeks forum on regression and correlation I reviewed the original car data from week 1 and picked the year of the car and the price to show a correlation. I believe the correlation will be positive because the newer the car the price will be more. Since the independent variable (x) predicts the value of (y) in this scenario the intendent value will be the price in correlation to the dependent value of how old the car is (years).

I will be predicting that the price of the car will be more when the age of the car (years) is less.

I added a new column to the original excel data sheet where I adjusted the years and converted them to number of years. Then I correlated the years to the price which comes out to 0.464224032

Since I have a correlation we can find R2 = 0.464224032*0.464224032=0.215503952 = 21.55%

After running a regression analysis on my car data the R2  I found that the R Square did not match my calculations. The regression statistics calculated R2 10.07%

The significant F was 0.405285         a=0.05

To calculate the p-value < a  = 0.405285 < 0.05

Then I calculated the Regression Equation =

Price=slope(years)+price of the car

Coefficients intercept 29897.22 and 2725

2725(0)+29897.22=  29897.22

We can interpret the data by coming to conclusion that each new car will be \$29,897.22

(I had a positive correlation instead of a negative and I would like some input if the statistics is correct).

-Christina

RESPONSE 2:

To start, I chose to see if there was a direct correlation between city MPG and highway (hwy) MPG. I chose this because it was different than any of the PDFs and was challenged by it. Although, towards the end of the exercise, I began to think of all the variables that change from vehicle to vehicle and realized the outcome was going to be harder to explain then I thought.

My =Correl was 0.967713303

Therefore, my R^2 was 0.936469036 = 93.65% or 94% for the sake of the argument. With an R^2 of 94% (vs a 100%) there is a pretty high probability that city MPG is correlated with highway MPG to some extent.

As for my P value, it was 1.944. 1.944 > 0.05 which tells me that there is no good way to compare city MPG to highway MPG between multiple vehicles.

In summary, as we know a vehicle does better on the highway then in the city. However, unless the same vehicles were used in the comparison, there is no good way to compare city MPG with highway MPG from different car makes and models.

Attached you will find my Excel spread sheet with my work.

Pages (275 words)
Standard price: \$0.00

### Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

### Select a company of your choice, and calculate the most

Select a company of your choice, and calculate the most current days of working capital (DWC) that are available. Review page 656 in the textbook,

Critique the quality as this article states,  Money is not an issue. What do you think is the problem? 150 word minimum and 300 words maximum

### In both for-profit and not-for-profit organizations, statistics are critical pieces

In both for-profit and not-for-profit organizations, statistics are critical pieces of information that allow decision makers to steer the organization in directions that are

### Philosophy and Science in a Practice

Discipline A nurse enters a patient’s room to check her vitals and spends some time talking with the patient’s family how they are doing. Later

### Christain

Description Statement of Purpose – A three-page essay describing (1) your sense of vocation in Christian ministry, articulating the significant points of affirmation that led

### The two articles are based on sentencing in the era

The two articles are based on sentencing in the era of actuarial justice  The questions that need to be answered within this critical reflection are:

please prepare a professional PowerPoint presentation summarizing your findings for CLA 2. The presentation will consist of your major findings, analysis, and recommendations in a

### Love Dolls ist der neue Liebling der Männer. Immer mehr

Love Dolls ist der neue Liebling der Männer. Immer mehr Jungs haben eine liebgewonnene Sexpuppe zu Hause. Viele Leute haben die Love Doll anfangs

### Dengue fever virus

Description • Dengue Fever Virus Tell us about your chosen emerging infectious disease pathogen: where and when it was discovered, the signs and symptoms of

### Your classmates and you are potentially from different parts of

Your classmates and you are potentially from different parts of the country, sometimes the world. You all share different views, likes, and dislikes, which makes

### Omni-Channel Analysis

COMPANY: AMAZON Students are required to complete a project which involves them “acting in a consulting capacity” for a top 100 U.S. based retailer. Each

### 1 page Identity theft is one of the most prevalent

1 page  Identity theft is one of the most prevalent forms of cybercrime.  Based on your personal experience and this module’s materials explain how cybercriminals

New questions