Run a linear regression using Excel’s Data Analysis regression
tool. Construct the linear regression equation and determine the
predicted total sales value if the number of promotions is 6. Is
there a significant relationship? Clearly explain your reasoning
using the regression results.
Number of Promotions
Total Sales
3
2554
2
1746
11
2755
14
1935
15
2461
4
2727
5
2231
14
2791
12
2557
4
1897
2
2022
7
2673
11
2947
11
1573
14
2980
1. Why is a predetermined overhead rate useful in "applying"
overhead costs in a manufacturing environment? Can you think of any
"downside" of using a predetermined overhead to apply/allocate
overhead costs to jobs/departments?
http://en.wikipedia.org/wiki/Pre-determined_overhead_rate (Links
to an external site.)
Explain why learning Excel could be useful outside of the work
environment.
Which unit concept did you think was the most difficult to
learn? Describe what you needed to do to clarify that concept. Add
the helpful information or video link if applicable.
As introduced in the book, linear regression could be useful for
which of the following scenarios?
a-Each observation in the data consists of a single, qualitative
variable.
b-Each observation in the data consists of two values, one for
each of two nominal variables.
c-Each observation in the data comes with two values, one for
each of two quantitative variables.
d-Each observation in the data consists of a single,
quantitative variable.
In a Financial Statement Analysis Report, what is the most
useful analytical tool ? Why? In what capacity would you use this
analytical tool in business career?
Simple Linear Regression: Suppose a simple
linear regression analysis provides the following
results:
b0 = 6.000, b1 =
3.000, sb0 =
0.750,
sb1 =
0.500, se = 1.364
and n = 24. Use this information to answer the following
questions.
(a) State the model equation.
ŷ = β0 + β1x
ŷ = β0 + β1x +
β2sb1
ŷ = β0 + β1x1 +
β2x2
ŷ = β0 +
β1sb1
ŷ = β0 +
β1sb1
x̂ = β0 +
β1sb1
x̂ = β0 +...