Please help me to derive the REGRESSION EQUATION as the medical cost being the Y value and weight as the X value. I provided the excel file i just don't know where to get it Medicalamount spentfor alcoholcostweightAge210020018550237825020042165710017537258420022554265825022032Which of the following factors has a significanteffect on medical expenses? Create the regressionequation for the problem. SUMMARY OUTPUTRegression StatisticsMultiple R 0.948553R Square 0.899753Adjusted R 0.866337Standard E 149.1055Chart AreaObservaticANOVAdfSMSignificance FRegressior1 598629.8 598629.8 26.92594 0.013899Residual3 66697.38 22232.46Total4 665327.2Coefficientsandard Erret StatP-value Lower 95%Upper 95%ower 95.0%pper 95.0%Intercept -1320.89 696.2576 -1.89713 0.154068 -3536.69 894.9147 -3536.69 894.9147Weight17.89198 3.448045 5.189021 0.0138996.9187628.86526.9187628.8652

From the output, the intercept is -1320.89.

Answered: lease help me to derive the REGRESSION…

lease help me to derive the REGRESSION EQUATION as the medical cost being the Y value and weight as the X value. I provided the excel file i just don't know where to get it

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Q: How is the number of drugs administered associated with readmissions for these patients? Regression…

A: Enter the data in Excel.

Q: Assume you were forecasting the demand of a table and you have 10 years of data. Using a static…

A: The seasonal indices for demand forecasting can be interpreted to give an estimated comparison with…

Q: The line of best fit through a set of data is y=-39.761 +3.894x According to this equation, what is…

A: The regression line is:y=−39.761+3.894x ; x is independent variable and y is dependent…

Q: Listed below are the numbers of cricket chirps in 1 minute and the corresponding temperatures in "E…

A: Use EXCEL to determine the regression equation. EXCEL procedure: Go to EXCEL Go to Data>Data…

Q: Ethel and Rick are planning a cross-country road trip. They have been gathering data on the cost of…

A: The given regression equation between the cost of renting the vintage car and the total number of…

Q: raised and spent (both in millions of dollars) by all congressional campaigns for 8 recent 2-year…

A: Given that:The table contains data related to the money raised and spent (both in millions of…

Q: The scatter plot shows the number of hours worked, x, and the amount of money spent on…

A: Given: sample size n = 24 Formula Used: The equation of the line of best fit: Y = a + bX b =…

Q: Suppose the equation of the regression line for the number of emails a person recieves at a…

A: The regression equation is given as y = 10 +4x , where the independent variable x is the number of…

Q: The volume (in cubic feet) of a black cherry tree can be modeled by the equation y=-51.3 +0.4x, +…

A: Given dataThe equation is y⏞=-51.3+0.4x1+5.1x2 and given values are x1=71 and x2=8.9

Q: A market analyst is interested in estimating the relationship between the miles per gallon of fuel…

Q: Use the time/tip data from the table below, which includes data from New York City taxi rides. (The…

A: The regression equation is obtained below as follows: From the information, given that Thus,

Q: XYZ Corporation's accountant, Salima, has suggested the company try regression as a method to…

A: The question is about regression.Given :Constant ( b0 ) = $35500X coefficient ( b1 ) = $6.50 per…

Q: acher plots the number of classes their students missed (r) with their scores on a test (y). The…

A: In this equation, the study of graphs is applied. Graph The graph of a function is the collection of…

Q: give step by step of regression analysis and explain it

A: Please find the solution below.

Q: Suppose the equation of the regression line for the number of emails a person recieves at a…

A: We have find critical value...

Q: A small theater company has a linear regression model to estimate y = the concession stand sales in…

Q: The equation of a regression line is Y = 5.8 + 4x Estimate the value of Y when x = 13?

A: Answer: From the given data, The regression equation is Y = 5.8+4x

Q: The equation used to predict annual cauliflower yield (in pounds per acre) is y = 24,209+4.556x₁…

A: given data regssion equation y^ = 24209+4.556x1-4.785x2we have to use this regression equation for…

Q: A real estate agent finds the following regression line for predicting the price of a house (y), in…

Q: An estimated regression equation was developed to predict the average number of runs given up per…

A: (a). Test whether MHPG significantly predict affect or not: Multiple linear regression model: A…

Q: Use the time/tip data from the table below, which includes data from New York City taxi rides. (The…

A: x is the predictor variable (time) y is the response variable (tip) Time(x) Tips(y) 27.00 0.00…

Q: Use the time/tip data from the table below, which includes data from New York City taxi rides. (The…

A: It is required to predict the tip (dollars) for a ride, using the time taken to complete that trip…

Q: A shoe store developed the following estimated regression equation relating sales to inventory…

A: The regression equation is y^=25+10x1+8x2.

Q: You determined there was a positive correlation between the number of study hours a week a student…

Q: The equation used to predict annual cauliflower yield (in pounds per acre) is y = 23,684 + 4.548x, -…

A: Given,equation is y^=23,684+4.548x1-4.744x2

Q: The volume (in cubic feet) of a black cherry tree can be modeled by the equation y = -50.6+0.4x₁…

A: Since you have posted a question with multiple sub parts, we will provide the solution only to the…

Q: If you were a student, inscribe the things you’ve learned about the different concepts of Linear…

A: Here I have to express, what is linear regression ? How to apply with real life situation ?

Q: Best Buy, a nationwide retailer of electronics, computers, and appliances, sells several brands of…

A: Solution: From the given information,

Q: The admissions officer for Clearwater College developed the following estimated regression equation…

A: To complete the missing entries in this Excel Regression tool output. dfRegression=number of…

Q: The equation of regression line is Y = 1.2 + 0.546 x. Estimate the value of Y when X = 8?

A: Answer: Given that, The equation of a regression line is Y = 1.2 + 0.546 X

Q: Explain how simple regression modeling can be extended to understand the relationship among several…

A: Independent and dependent variables in regression: In a simple regression, the variable of interest,…

Q: The line of best fit through a set of data is 6.227 – 1.507x According to this equation, what is the…

A: We have given that the line of best fit through a set of data is y^ = -6.227 - 1.507*x

Q: Use the time/tip data from the table below, which includes data from New York City taxi rides. (The…

A: x is the predictor variable (time) y is the response variable (tip) Time(x) Tips(y) 6.00 1.89…

Q: A shoe store developed the following estimated regression equation relating sales to inventory…

A: Solution: Given The estimated regression equation is y^= 23+12x1+6x2 Where x1= Inventory…

Q: The regression equation relating dexterity scores (x) and productivity scores (y) for the employees…

A: Answer:- Given, The regression equation relating dexterity scores (x) and productivity scores (y)…

Q: Given the regression model Y=15+7X what will be the value of Y when X is 0?

A: From the provided information, The regression model Y = 15 + 7X

Q: Please answer all questions fully, data included below. For the data in the accompanying table,…

A: Given data: Quality Alcohol (%) Chlorides (%) 6 10 0.067 6 11.8 0.064 5 9.1 0.076 5 9.5…

Q: Suppose Isabella has developed the following estimated regression equation for the price of an…

A: a) If someone wants to purchase an Edmonton condo with a size of 1010 square feet, how much should…

Q: For many people, breakfast cereal is an important source of fiber in their diets. Cereals also…

A: model Potassium =38+27Fiber From this model you can estimate a cerears potassium content from the…

Q: How can you find the amount of intercept in the regression involving standardized variables

A: Given information: The general linear regression model is given as Y=a+b1·X1+b2·X2.

Q: Please answer all questions fully, data included below. For the data in the accompanying table,…

A: Reviewing information, Given, Quality Alcohol (%) Chlorides (%) 6 10 0.067 6 11.8 0.064 5…

Question

Please help me to derive the REGRESSION EQUATION as the medical cost being the Y value and weight as the X value. I provided the excel file i just don't know where to get it

Medical
amount spent
for alcohol
cost
weight
Age
2100
200
185
50
2378
250
200
42
1657
100
175
37
2584
200
225
54
2658
250
220
32
Which of the following factors has a significant
effect on medical expenses? Create the regression
equation for the problem.

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.948553
R Square 0.899753
Adjusted R 0.866337
Standard E 149.1055
Chart Area
Observatic
ANOVA
df
S
MS
ignificance F
Regressior
1 598629.8 598629.8 26.92594 0.013899
Residual
3 66697.38 22232.46
Total
4 665327.2
Coefficientsandard Erre
t Stat
P-value Lower 95%Upper 95%ower 95.0%pper 95.0%
Intercept -1320.89 696.2576 -1.89713 0.154068 -3536.69 894.9147 -3536.69 894.9147
Weight
17.89198 3.448045 5.189021 0.013899
6.91876
28.8652
6.91876
28.8652

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

you are the Filipino analyst hired by the multinational company to study the sales data of its more than 75 stores worldwide. You used regression analysis to predict $ sales by using $ advertising (x1) and $ salary of sales representatives (x2) across all the branches. You obtained the following regression function: y = 7800 + 8.5x1-1.6x2 If the advertising budgets of one of the branches of the corporation is the same as before and the salary of sales representatives is now 20% less than before, then the predicted sales in that branch will
The volume (in cubic feet) of a black cherry tree can be modeled by the equation y = - 51.7 +0.4x, +4.7x2, where x, is the tree's height (in feet) and x, is the tree's diameter (in inches). Use the multiple regression equation to predict the y-values for the values of the independent variables. (a) x, = 72, x2 = 8.7 (b) x, = 65, x2 = 10.2 (c) x4 = 81, x2 = 17.5 (d) x, = 90, x2 = 20.7 %3D (a) The predicted volume is cubic feet. (Round to one decimal place as needed.)
A data set whose original x values ranged from 120 through 351 was used to generate a regression equation of ŷ=0.06x + 14.2. Use the regression equation to predict the value of y when x=110.
Need help If my outer regression equation is Weight= -191.891 + 5.06 (Height) How do I find the estimated weight LBS for an individual with height 76 inches?
I am doing as you instructed, but I keep getting an error "regression - input range non-numeric data". What can I do to solve this? Please help!
The line of best fit through a set of data is ý = 14.714 – 3.985x According to this equation, what is the predicted value of the dependent variable when the independent variable has value 180? Round to 1 decimal place.
The line of best fit through a set of data is y = - 42.824 – 3.033x According to this equation, what is the predicted value of the dependent variable when the independent variable has value 90? y = Round to 1 decimal place.
Please only answer “d” and “e” as I already have the other parts filled out. Thank you!
What are some ideas for practice problems that use the regression equation?
write the regression equation that will predict the number of manatees killed given thenumber of powerboat registrations (in 1000's). Show all work usingformulas for slope, b1, and y-intercept, b0, calculations roundingto 4-decimal places, if necessary. Show all the calculations and math of slope, b1, and y-intercept, b0, calculations roundingto 4-decimal places, if necessary. SHOW ALL WORK! DO NOT USE EXCEL! I need to be able to see every single part and how you got it. attached is the question
Please solve by hand as I need to understand the steps. Please don’t use excel
This question has do with linear regression.If I consider attendance in a class versus final grade in the class can you explain where there is a positive and when there is a negative relationship between them.