For the data set provided, create an Excel scatter chart with trendline for C=f(D); this is read "C is a function of D".

[answerhappygod]

For the data set provided, create an
Excel scatter chart with trendline for C=f(D); this is read "C is a
function of D". Show the Linear trendline equation on the
chart. Using the linear trendline equation, determine the
value α if we know (due to our design) that the real model is C=
2α∗D.
So how do we do this. First, you need to know that the
linear model has the form y=m*x+b. Next, you need to
recognize that we need to compare the two models element by
element. It should be pretty clear that C and y might be the
same, since they are both on the left side of the equation.
The next part is a little trickier. What you probably don't
know is that α and other Greek letters are often used to identify
constants, just like A, a, B, etc. Therefore, the value "2"
raised to a constant is just another number (in base 2). So,
it should now be much easier to believe that x and D are really the
'same'. The final issue is the "+b" part; there is not
anything like this in the model you are asked to use. Think
about how you would answer this if I wrote the model I want you to
use as y=x*2^α+0. Now, what if the "b" shown in my Excel
model is less than 1? If it is small (certainly less than 1
is small), what happens if I just say it is zero and throw it
out? Engineers are often faced with situations where we make
assumptions to allow us to 'move on'. We need to recognize
that there is an error, and that it is not perfect, but neither is
anything else. These assumptions are critical to engineering
decisions, but we always document them and recognize what might go
wrong because we just 'threw something out'.
So, set m= 2α and solve for α. Substitute the
value for m and you have the new model.
So quite simply and directly. Assume the
model
y=m*x+b looks
like C=
2α∗D+K
let
𝑚= 2𝛼
and b =
K
where m is from the Excel-generated model
now solve for alpha
Required elements for this problem:
Scatter plot
Trendline and
equation
Clearly identify the slope
from the Excel trendline
Calculate alpha
Graph properly identified
Please, clearly state how formulas are used in excel.
Thanks