Question

PLEASE ANSWER ALL QUESTIONS ! 1. The following sample observations were randomly selected: X Y 10...

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.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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.

Add a comment
Know the answer?
Add Answer to:
PLEASE ANSWER ALL QUESTIONS ! 1. The following sample observations were randomly selected: X Y 10...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 1. The following sample observations were randomly selected: X: 4 3 6 128 Y: 4 6...

    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...

    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...

    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.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...

    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 Regre...

    #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 cor...

    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)...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT