Find the Exponential Regression using the table. Write the initial amount, common ratio, and equation for the table.
1 answer:
Answer:
Initial temperature;
432.76
Common ratio;
-0.067
Equation;
Step-by-step explanation:
In this scenario, the time in minutes represents the independent variable x while the temperature of the pizza represents the dependent variable y.
The analysis is performed in Ms. Excel. The first step is to obtain a scatter plot of the data then finally inserting an exponential trend line to obtain the required equation.
The Ms. Excel output is shown in the attachment below. To obtain the initial temperature we substitute x = 0 in the equation. On the other hand, the common ratio is the exponent in the equation.
You might be interested in
Question:
Company 2007 Score 2008 Score
Rite Aid 73 76
Expedia 75 77
J.C. Penney 77 78
a. For Rite Aid, is the increase in the satisfaction score from 2007 to 2008 statistically significant? Use α= .05. What can you conclude?
b. Can you conclude that the 2008 score for Rite Aid is above the national average of 75.7? Use α= .05.
c. For Expedia, is the increase from 2007 to 2008 statistically significant? Use α= .05.
d. When conducting a hypothesis test with the values given for the standard deviation,
sample size, and α, how large must the increase from 2007 to 2008 be for it to be statistically significant?
e. Use the result of part (d) to state whether the increase for J.C. Penney from 2007 to 2008 is statistically significant.
Answer:
a. There is sufficient statistical evidence to suggest that the increase in satisfaction score for Rite Aid from 2007 to 2008 is statistically significant
b. There is sufficient statistical evidence to suggest that the 2008 Rite Aid score, is above the national average of 75.7
c. The statistical evidence support the claim of a significant increase from 2007 to 2008
d. 1.802 and above is significant
e. The increase of J. C. Penney from 2007 is not statistically significant.
Step-by-step explanation:
Here we have
n = 60
σ = 6
μ₁ = 73
μ₂ = 76
We put H₀ : μ₁ ≥ μ₂ and
Hₐ : μ₁ < μ₂
From which we have;
Plugging in the values we have
The probability, P from z function computation gives;
P(Z < -2.7386) = 0.0031
Where we have P < α, we reject the null hypothesis meaning that there is sufficient statistical evidence to suggest that the increase in satisfaction score for Rite Aid from 2007 to 2008 is statistically significant
b. To test here, we have
H₀ : μ ≤ 75.7
Hₐ : μ > 75.7
The test statistic is given as follows;
Therefore, we have the probability, P given as the value for the function at z = 0.3873 that is we have;
P = P(Z > 0.3873) = P(Z < -0.3873) = 0.3493
Therefore, since P > α which is 0.05, we fail to reject the null hypothesis, that is there is sufficient statistical evidence to suggest that the 2008 Rite Aid score, is above the national average of 75.7
c. Here we put
Null hypothesis H₀ : μ₁ ≥ μ₂
Alternative hypothesis Hₐ : μ₁ < μ₂
The test statistic is given by the following equation;
Plugging in the values we have
The probability, P from z function computation gives;
P(Z < -1.8257) = 0.03394
The statistical evidence support the claim of a significant increase
d. For statistical significance at 0.05 significant level, we have z = -1.644854
Therefore, from;
. we have;
Which gives
Therefore an increase of 1.802 and above is significant
e. Based on the result of part d. we have for J.C. Penney from 2007 to 2008 an increase of 1 which is less than 1.802 at 5% significant level, is not significant.