Which of the following equations are linear? - Answers 4y=8
A linear equation is a linear line. If a problem has a squared or a cubed term, it isn't linear. It is a
quadratic equation.
A vacation resort rents SCUBA equipment to certified divers. The resort charges an up-front fee of $25
and another fee of $12.50 an hour. What is the independent variable? - Answers Time.
The equation is
Dollars = $12.5(hour) + $25
Dollars depends on how many hours you use the equipment for.
Dollars is the dependent variable and time (in hours) is the independent variable.
You move out into the country and you notice every Spring there are more and more Deer Fawns that
appear. You decide to try and predict how many Fawns there will be for the up coming Spring.
You collect data to, to help estimate Fawn Count for the upcoming Spring season. You collect data on
over the past 10 years.
x1 = Adult Deer Count
x2 = Annual Rain in Inches
x3 = Winter Severity
Where Winter Severity Index:1 = Warm2 = Mild3 = Cold4 = Freeze5 = Severe
Estimate Fawn Count when Adult Deer Count = 10, Annual Rain = 13.5 and Winter Severity = 4
See Attached Excel for Data. - Answers 3.85
You can run a Multiple Linear Regression Analysis using the Data Analysis ToolPak in Excel.
Data -> Data Analysis -> Scroll to Regression
Highlight Fawn Count for the Y Input:
, Highlight columns Adult Count to Winter Severity for the X Input:
Make sure you click on Labels and Click OK
If done correctly then you look under the Coefficients for the values to write out the Regression
Equation
CoefficientsIntercept-5.559106707Adult Count0.303715877Annual Rain in Inches0.397827379Winter
Severity0.249286765
Fawn Count = -5.5591 + 0.3071(Adult Count) + 0.3978(Annual Rain) + 0.2493(Winter Severity)
Plug in, Adult Deer Count = 10, Annual Rain = 13.5 and Winter Severity = 4
Fawn Count = -5.5591 + 0.3071(10) + 0.3978(13.5) + 0.2493(4)
You are thinking about opening up a Starbucks in your area but what to know if it is a good investment.
How much money do Starbucks actually make in a year? You collect data to, to help estimate Annual Net
Sales, in thousands, of dollars to know how much money you will be making.
You collect data on 27 stores to help make your decision.
x1 = Rent in Thousand per month
x2 = Amount spent on Inventory in Thousand per month
x3 = Amount spent on Advertising in Thousand per month
x4 = Sales in Thousand per month
x5= How many Competitors stores are in the Area
Approximately what percentage of the variation in Annual Net Sales is accounted for by these 5
variables in this model?
See Attached Excel for Data. - Answers 98.24% of variation in the Annual Net Sales is accounted for by
Rent, Inventory, Advertising, Sales per Month and # of Competitor store in this model.
With Obesity on the rise, a Doctor wants to see if there is a linear relationship between the Age and
Weight and estimating a person's Systolic Blood Pressure. Is there a significant linear relationship
between Age and Weight and a person's Systolic Blood Pressure?
If so, what is/are the significant predictor(s) for Systolic Blood Pressure? - Answers Yes,
Age, p-value = 0.001303023 < .05, Yes, Age is a significant predictor for Systolic BP