Question
In: Statistics and Probability
CONO 2463 – Business Statistics Chapter 12 Complete the following parts to calculate (by hand) the...
CONO 2463 – Business Statistics
Chapter 12
- Complete the following parts to calculate (by hand) the estimated regression equation for x and y.
|
xi |
yi |
|
15 |
5 |
|
12 |
7 |
|
10 |
9 |
|
7 |
11 |
- Compute the estimated slope (b1).
- Compute the estimated intercept (b0).
- Write the estimated regression question you have calculated.
- A company has recorded data on the weekly sales for its product (y) and the unit price of the competitor’s product (x). Shown below is a portion of an Excel output for regression analysis.
|
Summary Output |
|||||
|
Regression Statistics |
|||||
|
Multiple R |
0.878 |
||||
|
R Square |
0.770 |
||||
|
Adjusted R Square |
0.725 |
||||
|
Standard Error |
1.644 |
||||
|
Observations |
7 |
||||
|
ANOVA |
|||||
|
df |
SS |
MS |
F |
Significance F |
|
|
Regression |
1 |
45.347 |
45.347 |
16.783 |
0.190 |
|
Residual |
5 |
13.509 |
2.701 |
||
|
Total |
6 |
58.857 |
|||
|
Coefficients |
Standard Error |
t Stat |
P-value |
||
|
Intercept |
3.58 |
3.6082 |
0.992 |
0.366 |
|
|
Price |
41.60 |
10.1552 |
4.096 |
0.190 |
|
- Write the estimated regression equation from the Excel Output. Using that equation, if the competitor’s price is $0.30, what are the predicted weekly sales?
- Conduct the significance test for the relationship between Sales and Competitor’s Price using the t-test (or F-test). Include null and alternative hypotheses, comparison to alpha of 5%, decision and conclusions.
Solutions
orchestra answered 3 years agoRelated Solutions
Calculate the descriptive statistics below for the following data. You should calculate them by hand and...
Calculate the descriptive statistics below for the following data.
You should calculate them by hand and show your work.
X = [ 6, 0, 13, 10, 7, 16, 13 ]
(a) mode
(b) median
(c) mean
(d) 20% trimmed mean
(e) range
(f) interquartile range
(g) sample standard deviation
(h) winsorized sample standard deviation
Can a complete solution to Problem 34E from Chapter 15 of the Business Statistics Communicating with...
Can a complete solution to Problem 34E from Chapter 15 of the
Business Statistics Communicating with Numbers Textbook (2nd
edition), please be provided?
An automotive workers union, in conjunction with top management,
is negotiating a new hourly pay policy for union workers based on
three variables: (1) job class, (2) years with the company, and (3)
years as a union member at any company. The goal is to develop an
equitable model that can objectively specify hourly pay, thereby
reducing...
Use the given statistics to complete parts (a) and (b). Assume that the populations are normally...
Use the given statistics to complete parts (a) and (b). Assume
that the populations are normally distributed. (a) Test whether mu
1greater thanmu 2 at the alphaequals0.10 level of significance for
the given sample data. (b) Construct a 99% confidence interval
about mu 1minusmu 2. Population 1 Population 2 n 25 19 x overbar
46.9 43.1 s 6.9 12.3 (a) Identify the null and alternative
hypotheses for this test. A. Upper H 0: mu 1less thanmu 2 Upper H
1:...
Use the given statistics to complete parts (a) and (b). Assume that the populations are normally...
Use the given statistics to complete parts (a) and (b). Assume
that the populations are normally distributed.
(a) Test whether μ1>μ2 at the α=0.01 level of significance
for the given sample data.
(b) Construct a 99% confidence interval about μ1−μ2.
Population 1
Population 2
n
29
21
x overbarx
51.1
41.5
s
4.3
14.8
(a) Identify the null and alternative hypotheses for this
test.
A. H0: μ1≠μ2
H1: μ1=μ2
B. H0: μ1>μ2
H1: μ1=μ2
C. H0: μ1=μ2
H1: μ1≠μ2
D....
Use the given statistics to complete parts (a) and (b). Assume that the populations are normally...
Use the given statistics to complete parts (a) and (b). Assume
that the populations are normally distributed. (a) Test whether mu
1 greater than mu 2 at the a=0.05 level of significance for the
given sample data. (b) Construct a 95% confidence interval about
mu 1 - mu 2.
(a) Identify the null and alternative hypotheses for this
test.
population 1
population 2
n
23
16
x
50.5
41.6
s 6.7 11.7
Use the given statistics to complete parts (a) and (b). Assume that the populations are normally...
Use the given statistics to complete parts (a) and (b). Assume
that the populations are normally distributed.
(a) Test whether u1 > u2 at the a=0.01level of significance for
the given sample data.
(b) Construct a 90% confidence interval about
u1-u2
Population 1
Population 2
n
29
22
x overbarx
45.8
43.4
s
4.9
11.7
Use the given statistics to complete parts (a) and (b). Assume that the populations are normally...
Use the given statistics to complete parts (a) and (b). Assume
that the populations are normally distributed.
(a) Test whether
mu 1μ1greater than>mu 2μ2
at the
alphaαequals=0.050.05
level of significance for the given sample data.(b) Construct a
9595%
confidence interval about
mu 1μ1minus−mu 2μ2.
Population 1
Population 2
n
2525
1919
x overbarx
47.547.5
40.740.7
s
5.75.7
10.710.7
(a) Identify the null and alternative hypotheses for this
test.
A.
Upper H 0H0:
mu 1μ1less than<mu 2μ2
Upper H 1H1:
mu...
Use the given statistics to complete parts (a) and (b). Assume that the populations are normally...
Use the given statistics to complete parts (a) and (b). Assume
that the populations are normally distributed.
(a) Test whether μ1> μ2 at the alphaα=0.05
level of significance for the given sample data.
(b) Construct a 99% confidence interval about
μ1−μ2
population1
population2
n
21
19
x bar
48.5
42.3
s
7.1
11.9
(a) Identify the null and alternative
hypotheses for this test.
A. H0: μ1 =μ2
H1: μ1<μ2
B.H0:μ1 < μ2
H1:μ1=μ2
C. H0:μ1>μ2
H1:μ1= μ2
D. H0: μ1≠...
Use the given statistics to complete parts (a) and (b). Assume that the populations are normally...
Use the given statistics to complete parts (a) and (b). Assume
that the populations are normally distributed.
Population 1 Population 2
n=24 n=17
x=47.4 x=42.2
s=6.2 s=9.7
(a) Test whether μ1>μ2 at the α=0.05 level of significance
for the given sample data.
(b) Construct a 99% confidence interval about μ1−μ2.
Statistics - Calculate difference in proportions and chi-square values. Do by hand, not in R or...
Statistics - Calculate difference in proportions and chi-square
values.
Do by hand, not in R or Excel. Show formulas
1) Calculate difference in proportions
2) Calculate chi-square values
Cell phones and cancer
Cancer
Cancer
Cell phone
Yes
No
Yes
53
102
No
485
693
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- What 2 things happen to the melting point of a solid when an impurity is present?
- How Can Hominin Evolution be characterized as " mosaic evolution" Use examples of species from the...
- Absorption and Variable Costing Income Statements for Two Months and Analysis During the first month of...
- Mobile and wireless devices are being increasingly used in the Business Administration and Management Industry. write...
- What are the options that might be considered in relation to introducing flexible work practices? What...
- Question 2 : Aggregate Scores: Write a program that opens 2 files, quiz.txt, and hw.txt. The...
- Define the term symbiosis specifically as it applies in a biological context. Compare and contrast parasitism,...
ADVERTISEMENT