Question
Number Number of Value Cost Value of New of Production Added by of Industry Capital End-of-Year Industry Employees Workers Manufacturing Materials Shipments Expenditures Inventories Group
| Number | Number of | Value | Cost | Value of | New | ||||
| of | Production | Added by | of | Industry | Capital | End-of-Year | Industry | ||
| Employees | Workers | Manufacturing | Materials | Shipments | Expenditures | Inventories | Group | ||
| SIC Code | Industry | (1,000) | (1,000) | (millions) | (millions) | (millions) | (millions) | ||
| 201 | Meat products | 433 | 370 | 23518 | 78713 | 102103 | 1833 | 3630 | 1 |
| 202 | Dairy products | 131 | 83 | 15724 | 42774 | 58123 | 1056 | 3157 | 1 |
| 203 | Preserved fruits & vegetables | 204 | 169 | 24506 | 27222 | 51708 | 1405 | 8732 | 1 |
A. Use excel to find the regression equation to predict the average PE ratio from the other variables presented. B. From your output, write the result in the form of an equation. C. What is the value of R2? Based on R2 and the global test, does this relationship appear to be significant at the .05 level of significance? D. Conduct a test of hypothesis on each individual variable at the .10 level of significance. Are there any variables that should be deleted? E. Use excel to find the regression equation again, this time use only those variables that appear to have a significant relationship (as determined in part D) to the average PE ratio.
What are the steps on EXCEL?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started