Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Company Year Metric Value Company A 2 0 2 0 Advertising Spend 5 0 , 0 0 0 Company A 2 0 2 0 Sales

Company Year Metric Value
Company A
2020
Advertising Spend
50
,
000
Company A
2020
Sales Team Size
4
Company A
2020
Website Traffic
200
,
000
Company A
2020
Revenue
100
,
000
Company A
2021
Advertising Spend
60
,
000
Company A
2021
Sales Team Size
5
Company A
2021
Website Traffic
220
,
000
Company A
2021
Revenue
110
,
000
Company A
2022
Advertising Spend
45
,
000
Company A
2022
Sales Team Size
3
Company A
2022
Website Traffic
180
,
000
Company A
2022
Revenue
95
,
000
Company B
2020
Advertising Spend
70
,
000
Company B
2020
Sales Team Size
6
Company B
2020
Website Traffic
240
,
000
Company B
2020
Revenue
120
,
000
Company B
2021
Advertising Spend
55
,
000
Company B
2021
Sales Team Size
4
Company B
2021
Website Traffic
210
,
000
Company B
2021
Revenue
105
,
000
Company B
2022
Advertising Spend
65
,
000
Company B
2022
Sales Team Size
5
Company B
2022
Website Traffic
230
,
000
Company B
2022
Revenue
115
,
000
Company C
2020
Advertising Spend
40
,
000
Company C
2020
Sales Team Size
3
Company C
2020
Website Traffic
170
,
000
Company C
2020
Revenue
90
,
000
Company C
1978
Revenue
1
,
000
,
000
Company C
2021
Advertising Spend
75
,
000
Company C
2021
Sales Team Size
6
Company C
2021
Website Traffic
250
,
000
Company C
2021
Revenue
125
,
000
Company C
2022
Advertising Spend
50
,
000
Company C
2022
Sales Team Size
4
Company C
2022
Website Traffic
200
,
000
Company C
2022
Revenue
100
,
000 based on this question, i have solved the regression, can you please checj and tell me if i am right SUMMARY OUTPUT
Regression Statistics
Multiple R 1
R Square 1
Adjusted R Square 1
Standard Error 3.14156E-13
Observations 9
ANOVA
df SS MS F Significance F
Regression 31100000000366666666.73.71518E+338.68364E-84
Residual 54.93471E-259.86941E-26
Total 81100000000
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 500003.27989E-121.52444E+162.30541E-8050000500005000050000
Advertising spent 18.00111E-171.24983E+166.22381E-801111
Website Traffic -1.92933E-163.68833E-17-5.2309010130.003379209-2.87745E-16-9.81214E-17-2.87745E-16-9.81214E-17
Sales size -3.30263E-134.6697E-13-0.7072461870.511004567-1.53065E-128.70121E-13-1.53065E-128.70121E-13
RESIDUAL OUTPUT
Observation Predicted Revenue Residuals
1100000-1.45519E-11
2110000-1.45519E-11
395000-1.45519E-11
4120000-1.45519E-11
5105000-1.45519E-11
6115000-1.45519E-11
790000-1.45519E-11
8125000-1.45519E-11
9100000-1.45519E-11 please tell me hypothesis test for this data briefly

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Tax Accounting

Authors: Greg Shields

1st Edition

163716128X, 978-1637161289

Students also viewed these Accounting questions

Question

List the key components within occupational health and safety.

Answered: 1 week ago

Question

Identify the general types of employment laws in Canada.

Answered: 1 week ago

Question

Describe discrimination and harassment in the workplace.

Answered: 1 week ago