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: The table below shows the average weekly wages (in dollars) for state government employees and…

A: The data shows the average weekly wages for state government employees and federal government…

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: A statistician wants to see if there is a relationship between Salary and Age, where Salary is…

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: You determined there was a positive correlation between the number of study hours a week a student…

A: Given data y^=1.176x+43Also given thatx=12

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 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: 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: Substitute into the regression model (equation) to predict monthly sales if $6250 is spent on…

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: Business Science textbook stated that the longer the trading hours, the higher the turnovers. Based…

A: The regression line is y= 900+1500 x and trading hours = 16 hours per day.

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

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: I have done this type of example 5 times. I know I have the regression equation right. But I don't…

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: 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: You determined there was a positive correlation between the number of study hours a week a student…

A: Given regression equation isy=2.079x+41If x=14y=?

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: What is the slope and intercept for the regression equation given this data? X = 72, 81, 54, 50, -3…

A: Given that X Y 72 69 81 97 54 73 50 22 -3 -10

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: You determined there was a positive correlation between the number of study hours a week a student…

A: The regression equation of y on x is given by y = 2.072x + 49 Where, y = test score, and x = number…

Q: you are the Filipino analyst hired by the multinational company to study the sales data of its more…

A: We know, y = 7800 + 8.5 x1 - 1.6 x2 Since the value of coefficient of x2 is negative, this implies…

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

A: Given, y^ = -51.7+0.4x1+4.7x2 where x1 is the tree's height and x2 is the tree's diameter

Q: Need help If my outer regression equation is Weight= -191.891 + 5.06 (Height) How do I find the…

A: The linear regression equation is given by,

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

A: From the provided information,The estimated multiple regression equation is x1 is the tree's…

Q: What is the best predicted test score for a student who spent 120 minutes preparing for the test?

A: Regression equation for dependent random variable Y (test score ) and Independent random variable X(…

Q: I am doing as you instructed, but I keep getting an error "regression - input range non-numeric…

A: Please find the explanation below.

Q: What are some ideas for practice problems that use the regression equation?

A: Regression Equation is one of the most commonly used techniques in statistics. It is used to…

Q: You believe that more than one variable likely leads to teacher success (Y) and you think that both…

Q: The linear regression equation for the data from the number 2 is y=.27x+5.82. Describe the slope…

A: GivenLinear regression equation is y=0.27x+5.82

Q: Height Weight GPA Study TV Computer FamilySz Floors stairs friends female Acctg Mgmt Mktg Fin IntBus…

A: The equation to be of form y=b0+b1x1+b2x2+b3x3+e Follow the steps below to get the Regression…

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

A: Given Multiple regression equation is y^= -51.2+0.4x1+4.8x2

Q: A sports-equipment researcher was interested in the relationship between the speed of a golf club…

A: The slope of regression line: The linear regression line has the equation of the form Y=a+bX. where:…

Q: (a) Find the predicted value for the data point and compute the residual.

A: Here given , Weight ^ = 92 + 11.9 (Training)

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

A: Comments : As per our guidelines we are supposed to answer only three subparts. kindly repost other…

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

The volume (in cubic feet) of a black cherry tree can be modeled by the equation y=−51.9+0.3x1+4.9x2, where x1 is the tree's height (in feet) and x2 is the tree's diameter (in inches). Use the multiple regression equation to predict the y-values for the values of the independent variables.
The volume (in cubic feet) of a black cherry tree can be modeled by the equation y = -51.5+0.3x, +5.3x2, 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. x₁ = 72. x₂ = 8.9 The predicted volume is cubic feet. (Round to one decimal place as needed.)
The personnel director for Electronics Associates developed the following estimated regression equation relating an employee's score on a job satisfaction test to length of service and wage rate. ŷ = 14.4 − 8.69x1 + 13.52x2 where x1 = length of service (years) x2 = wage rate (dollars) y = job satisfaction test score (higher scores indicate greater job satisfaction). #1) Find the value of the test statistic. (Round your answer to two decimal places.) F = Find the p-value. (Round your answer to three decimal places.) p-value = #2)Did the estimated regression equation provide a good fit to the data? Explain. (Round your answers to two decimal places.) Since R2 = Ra2 = #3) Find the value of the test statistic for ?2. (Round your answer to two decimal places.) Find the p-value. (Round your answer to three decimal places.) p-value =
How to know if obtaining a regression equation for the data appear reasonable?
Please solve all parts. Thanks
Using the weights (lb) and highway fuel consumption amounts (mi/gal) of the 48 cars listed in the accompanying data set, one gets this regression equation: y = 58.9-0.00749x, where x represents weight. Complete parts (a) through (d). Click the icon to view the car data. The site to your captio V.UVITU. D. The slope is -0.00749 and the y-intercept is 58.9. c. What is the predictor variable? ... OA. The predictor variable is highway fuel consumption, which is represented by x. OB. The predictor variable is highway fuel consumption, which is represented by y. C. The predictor variable is weight, which is represented by x. OD. The predictor variable is weight, which is represented by y. d. Assuming that there is a significant linear correlation between weight and highway fuel consumption, what is the best predicted value for a car that weighs 2994 lb? The best predicted value of highway fuel consumption of a car that weighs 2994 lb is (Round to one decimal place as needed.) mi/gal.
What are some important applications of regression analysis in the real world?
Data was collected for a regression analysis comparing car weight and fuel consumption. b0 was found to be 32.7, b1 was found to be -7.6, and R2 was found to be 0.86. Interpret the y-intercept of the line. On average, each one unit increase in the weight of a car decreases its ful consumption by 7.6 units. On average, when x=0, a car gets -7.6 miles per gallon. On average, when x=0, a car gets 32.7 miles per gallon. On average, each one unit increase in the weight of a car increases its fuel comsumption by 32.7 units. We should not interpret the y-intercept in this problem.
please please help me i need help
The volume (in cubic feet) of a black cherry tree can be modeled by the equation y = - 50.8 + 0.3x, +4.5x,, 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. x, = 70, x, = 8.6 The predicted volume is cubic feet. (Round to one decimal place as needed.)
please answer the third and fourth part
Please solve only part d) and part e)