PLEASE ANSWER ALL QUESTIONS !
1. The following sample observations were randomly
selected:
|
X |
Y |
|
10 |
4 |
|
5 |
6 |
|
6 |
5 |
|
4 |
7 |
|
3 |
7 |
What is the coefficient of correlation?
Select one:
a. 0.90
b. -0.46
c. -0.95
d. 0.82
2. The regression output from Excel indicates that the Significance F is 0.001. Does that mean there is a significant relationship?
Select one:
a. Yes, because it is small.
b. Yes, because it is large.
c. No, because it is small.
d. No, because it is large.
3. A business is evaluating their advertising budget, and wishes
to determine the relationship between advertising dollars spent and
changes in revenue. Below is the output from their
regression.
|
SUMMARY OUTPUT |
|
Regression Statistics |
|
Multiple R |
0.95 |
|||||
|
R Square |
0.90 |
|||||
|
Adjusted R Square |
0.82 |
|||||
|
Standard Error |
0.82 |
|||||
|
Observations |
8 |
|||||
|
ANOVA |
||||||
|
df |
SS |
MS |
F |
Significance F |
||
|
Regression |
3 |
23.188 |
7.729 |
11.505 |
0.020 |
|
|
Residual |
4 |
2.687 |
0.672 |
|||
|
Total |
7 |
25.875 |
||||
|
Coefficients |
Std Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
|
|
Intercept |
83.91 |
2.03 |
41.36 |
0.00 |
78.28 |
89.54 |
|
TV ($k) |
1.96 |
0.48 |
4.10 |
0.01 |
0.63 |
3.29 |
|
Radio ($k) |
0.76 |
0.47 |
1.64 |
0.18 |
-0.53 |
2.05 |
|
Newspaper ($k) |
1.76 |
1.93 |
0.91 |
0.41 |
-3.60 |
7.11 |
What percentage of the change in revenue can be explained by
changes in advertising dollars?
Select one:
a. 0.95
b. 0.90
c. 83.91
d. 1.96.
Answer - 1: Correlation coefficient of given data = -0.95
Option C is correct.
Answer - 2: Option A is correct.
Answer - 3: Option B is correct.
PLEASE ANSWER ALL QUESTIONS ! 1. The following sample observations were randomly selected: X Y 10...
1. The following sample observations were randomly selected: X: 4 3 6 128 Y: 4 6 5 7a7129 Determiner and r?. Determine the regression equation. Determine Sand Sy. Draw the scatter diagram. At the .05 significance level, is the correlation in the population greater than zero? (Say what the hypotheses are, what the test statistic is, what the critical value(s) is (are), what your decision is regarding the null hypothesis.) оу 4 У 4 5 6 3 5 6 7...
A sample with two variables (x and y) is given in the table. According to the sample, please develop an excel spreadsheet to calculate the missing values given in the table of “summary output” attached below. The excel spreadsheet needs to be submitted together with your assignment. Note: You can use “data analysis toolpak” to check your answers, but calculations should be based on the formulas that we learnt in module 2. x y 1.0 5.2 1.5 7.2 2.0 5.5...
4. Part of an Excel output relating X (independent variable) and Y (dependent variable) is shown below. Fill in all the blanks marked with "?". Summary Output Regression Statistics Multiple R ? R Square ? Adjusted R Square 0.8125 Standard Error 1.3693064 Observations 7 ANOVA df SS MS F Significance F Regression ? 50.625 ? ? ? Residual ? 9.375 ? Total 6 60 Coefficients Standard Error. t Stat P-value Lower 95% Intercept 13.75 1.398341. 9.833082 0.0001853 10.15555 x -1.125...
1.a. Conduct a two-sample t-test to find out if there is a
significant difference between U.S. stock returns and U.S.
corporate bond returns using the monthly data covering the sample
period 1980-2017. 1.b. Conduct a two-sample t-test to find out if
there is a greater returns for U.S. stock as compared to U.K. stock
returns using the monthly data covering the sample period
1980-2017. 2. Estimate a multiple linear regression relationship
with the U.K. stock returns as the dependent variable,...
The following output is regression of hourly EARNINGS ON HEIGHT a. Create a 99% confidence interval for the slope coufficient and interpretit D. is the slope cofficient on HEIGHT statistically significant at a level of significance of 197. Years of schooling Salso acts EARNINGS but has not been added to the regression. Where does the effect of Soccur in this regression output? SUMMARY OUTPUT Regression Statistics Multiple R 0.241124399 R Square 0.058140976 Adjusted R Square 0.056390309 Standard Error 15.96556082 Observations...
#9 need help all of it
SUMMARY OUTPUT Regression Statistics Multiple R 0.89079322 R Square Adjusted R S 0.78995244 Standard Erro 3.04000462 Observations 0.79351257 60 ANOVA MS Significance F df Regression 1 2059.8551 2059.8551222.888768 1.5799E-21 58 536.014429 9.24162808 59 2595.86953 3 Residual Total er 95% Lower 98.0% Upper 98.0% 4.70337792 0.85182782 5.52151244 8.2562E-07 2.99825928 6.40849657 2.66548423 6.74127162 ertising 2.04813433 0.13718744 14.9294597 1.5799E-21 1.77352384 2.32274483 1.7199302 2.37633847 Coefficients Standard Errot Stat P-value Lower 95% Intercept Adv 9. A marketing manager claims...
The following sample observations were randomly selected. 4 4 X. 6 3 15 13 11 95 13 15 7 Determine the correlation coefficient and interpret relationship between X and Y. the Name Student ID Date Classwork of chapter21 1. A goatherd has the cost function cly)-Sy' where y is the number of tubs of goat cheese she makes per month. She faces a competitive market for goat cheese, with a price of $100 a tub. How many tubs should she...
Part of an Excel output relating 15 observations of X (independent variable) and Y (dependent variable) is shown below. Provide the values for a-e shown in the table below. (See section 15.5) Summary Output ANOVA df SS MS F Significance F Regression 1 2.7500 -d- -e- 0.632 Residual -a- -b- 11.45 Total 14 -c- A Company has recorded data on daily demand for its product (y in thousands of units) and the unit price (x in hundreds of dollars). A...
Logout This preamble applies to all the remaining questions. The questions are based on the lecture example for regression with categorical data. In the lecture example, we were analyzing the association of Repair time (y), the dependent variable, with the Time since last service (X1), and the Repair type (x2). Where x2 was a dummy variable coded 1 for an electrical repair and 0 for a mechanical repair. This time we inversely coded x2 ; i.e. x2 = 1 if...
The following output may be used in several questions. A movie industry analyst is interested in predicting box office revenue revenue") in millions of dollars using the production budget ("budget"), also in millions of dollars. A simple linear regression model has been fit. The output is shown below, with some missing values indicated by shaded areas Regression Statlstics Multiple R 0.626 R Square 0.392 Adjusted R Square 0.387 Standard Error 49.458 Observations 120 ANOVA Signficance F df SS MS F...