Company NameRevenueCapitalizationAvis Budget Group-291175.8United Stationers1091381.6Owens Corning2763417.8Foot Locker2783547.6Alliant Techsystems313.21891.9Fidelity National Financial369.53461.4FMC Technologies399.812520.3Ralph Lauren567.612522.8Ralph Lauren567.612522.8Harley-Davidson599.18925.3Kroger60213819.5Pitney Bowes617.53681.2Pitney Bowes617.53681.2Amazon.com63181458.6Rockwell Collins6348560.5Rockwell Automation697.810514.8Rockwell Automation697.810514.8AmerisourceBergen706.610087.6Delta Air Lines8547082.1Cardinal Health95914115.2Medco Health Solutions1,455.7021865.9Costco Wholesale1,462.0036461.2HCA Holdings2,465.009550.2Lockheed Martin2,655.0026651.1CVS Caremark3,461.0053575.7Kraft Foods3,527.0065917.4Boeing4,018.0055188.8United Technologies4,979.0066606.5UnitedHealth Group5,142.0053469.4Cisco Systems6,490.0097376.2Coca-Cola8,572.00157130.5General Motors9,190.0032382.4Procter & Gamble11,797.00182109.9Procter & Gamble11,797.00182109.9ConocoPhillips12,436.0095251.9Company NameRevenueCapitalizationAvis Budget Group-291175.8United Stationers1091381.6Owens Corning2763417.8Foot Locker2783547.6Alliant Techsystems313.21891.9Fidelity National Financial369.53461.4FMC Technologies399.812520.3Ralph Lauren567.612522.8Ralph Lauren567.612522.8Harley-Davidson599.18925.3Kroger60213819.5Pitney Bowes617.53681.2Pitney Bowes617.53681.2Amazon.com63181458.6Rockwell Collins6348560.5Rockwell Automation697.810514.8Rockwell Automation697.810514.8AmerisourceBergen706.610087.6Delta Air Lines8547082.1Cardinal Health95914115.2Medco Health Solutions1,455.7021865.9Costco Wholesale1,462.0036461.2HCA Holdings2,465.009550.2Lockheed Martin2,655.0026651.1CVS Caremark3,461.0053575.7Kraft Foods3,527.0065917.4Boeing4,018.0055188.8United Technologies4,979.0066606.5UnitedHealth Group5,142.0053469.4Cisco Systems6,490.0097376.2Coca-Cola8,572.00157130.5General Motors9,190.0032382.4Procter & Gamble11,797.00182109.9Procter & Gamble11,797.00182109.9ConocoPhillips12,436.0095251.9A.What is the value of R square? The answer is . (Make sure two decimal places.)B.What is the coefficient of the intercept? The answer is . (Make sure two decimal place and no comma. EX: 34215.22)C.What is the p-value of the intercept? The answer is . (Make sure two decimal places.)D.What is the coefficient of the “Revenue” variable? The answer is . (Make sure two decimal places.)E.Is the “Revenue” variable significant? The answer is . (Yes = 1, No = 2)

The data shows the revenue and capitalization for each company.A. The regression analysis is conducted using EXCEL. The software procedure is given below: Enter the data. Select Data > Data Analysis >Regression> OK. Enter Input Y Range as C1:C36. Enter Input X Range as B1:B36. Mark Labels. Click OK. The output is, From the output, the value of R square is 0.74. Therefore, the value of R square is 0.74.B. From the output, the coefficient of intercept is 5380.66. Therefore, the coefficient of the intercept is 5380.66.C. From the output, the p-value of the intercept is 0.34. Therefore, the p-value of the intercept is 0.34.D. From the output, the coefficient of "Revenue" variable is 11.73. Therefore, the coefficient of "Revenue" variable is 11.73.E. The hypothesis is, Null hypothesis: H0:β1=0 Alternative hypothesis: Ha:β1≠0 From the output, the p-value of the "Revenue" variable is 0.00. Decision rule: If p-value less than level of significance, then reject the null hypothesis. Conclusion: The p-value is less than for any level of significance. Based on the decision rule, reject the null hypothesis. Therefore, the "Revenue" variable is significant. Correct Answer: 1.

Answered: A.What is the value of R square? The…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

Company Name	Revenue	Capitalization
Avis Budget Group	-29	1175.8
United Stationers	109	1381.6
Owens Corning	276	3417.8
Foot Locker	278	3547.6
Alliant Techsystems	313.2	1891.9
Fidelity National Financial	369.5	3461.4
FMC Technologies	399.8	12520.3
Ralph Lauren	567.6	12522.8
Ralph Lauren	567.6	12522.8
Harley-Davidson	599.1	8925.3
Kroger	602	13819.5
Pitney Bowes	617.5	3681.2
Pitney Bowes	617.5	3681.2
Amazon.com	631	81458.6
Rockwell Collins	634	8560.5
Rockwell Automation	697.8	10514.8
Rockwell Automation	697.8	10514.8
AmerisourceBergen	706.6	10087.6
Delta Air Lines	854	7082.1
Cardinal Health	959	14115.2
Medco Health Solutions	1,455.70	21865.9
Costco Wholesale	1,462.00	36461.2
HCA Holdings	2,465.00	9550.2
Lockheed Martin	2,655.00	26651.1
CVS Caremark	3,461.00	53575.7
Kraft Foods	3,527.00	65917.4
Boeing	4,018.00	55188.8
United Technologies	4,979.00	66606.5
UnitedHealth Group	5,142.00	53469.4
Cisco Systems	6,490.00	97376.2
Coca-Cola	8,572.00	157130.5
General Motors	9,190.00	32382.4
Procter & Gamble	11,797.00	182109.9
Procter & Gamble	11,797.00	182109.9
ConocoPhillips	12,436.00	95251.9

Company Name	Revenue	Capitalization
Avis Budget Group	-29	1175.8
United Stationers	109	1381.6
Owens Corning	276	3417.8
Foot Locker	278	3547.6
Alliant Techsystems	313.2	1891.9
Fidelity National Financial	369.5	3461.4
FMC Technologies	399.8	12520.3
Ralph Lauren	567.6	12522.8
Ralph Lauren	567.6	12522.8
Harley-Davidson	599.1	8925.3
Kroger	602	13819.5
Pitney Bowes	617.5	3681.2
Pitney Bowes	617.5	3681.2
Amazon.com	631	81458.6
Rockwell Collins	634	8560.5
Rockwell Automation	697.8	10514.8
Rockwell Automation	697.8	10514.8
AmerisourceBergen	706.6	10087.6
Delta Air Lines	854	7082.1
Cardinal Health	959	14115.2
Medco Health Solutions	1,455.70	21865.9
Costco Wholesale	1,462.00	36461.2
HCA Holdings	2,465.00	9550.2
Lockheed Martin	2,655.00	26651.1
CVS Caremark	3,461.00	53575.7
Kraft Foods	3,527.00	65917.4
Boeing	4,018.00	55188.8
United Technologies	4,979.00	66606.5
UnitedHealth Group	5,142.00	53469.4
Cisco Systems	6,490.00	97376.2
Coca-Cola	8,572.00	157130.5
General Motors	9,190.00	32382.4
Procter & Gamble	11,797.00	182109.9
Procter & Gamble	11,797.00	182109.9
ConocoPhillips	12,436.00	95251.9

A.What is the value of R square? The answer is . (Make sure two decimal places.)

B.What is the coefficient of the intercept? The answer is . (Make sure two decimal place and no comma. EX: 34215.22)

C.What is the p-value of the intercept? The answer is . (Make sure two decimal places.)

D.What is the coefficient of the “Revenue” variable? The answer is . (Make sure two decimal places.)

E.Is the “Revenue” variable significant? The answer is . (Yes = 1, No = 2)

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 6 steps with 1 images

SEE SOLUTION Check out a sample Q&A here