Reference no: EM131319860
Regression analysis
Calculate then explain/interpret the following 14 tasks/tests using the dependent variable (labeled Y)(Sales) and the independent variables (labeled X1 (Calls), X2 (Time), and X3(Years)). Attached is the excel Spreadsheet with the variables.
1. Generate a scatterplot for Y vs X1, including the graph of the "best fit" line. Interpret.
2. Determine the equation of the "best fit" line
3. Determine the coefficient of correlation. Interpret.
4. Determine the coefficient of determination. Interpret.
5. Test the utility of this regression model. Interpret results, including the p-value.
6. Based on items 1-5, analyze the ability of X1 to predict Y
7. Compute a 95% CI for β1 (the population slope). Interpret this interval.
8. Estimate the average for the dependent variable when X1 = 170 using an interval. Interpret.
9. Predict the value of the dependent variable when X1=170 using an interval. Interpret.
10. What can be said about the value of the dependent variable for values of X1 outside the range of the sample values? Explain. Build a model to predict the dependent variable/Y using all of the independent variables/ X1, X2, and X3
11. Prepare a multiple regression model using the designated dependent and 3 independent variables. Explain the equation for this multiple regression model in simple terms.
12. Perform the Global Test for Utility (F-Test). Explain the conclusion.
13. Perform the t-test on each independent variable. Explain the conclusions including your recommendation on which independent variables should be kept and which should be discarded. If any independent variables are to be discarded, re-run the multiple regression, including only the significant independent variables, and summarize your finding on this final model.
14. Is this multiple regression model better than the linear model generated in parts 1-10? Explain.
|
Foreign exchange risk was once overlooked
: Foreign exchange risk was once overlooked—perhaps thought to be of lesser overall importance—in corporate financial planning. Why should foreign exchange risk be particularly stressed in today’s corporate finance environment? Do you expect that forei..
|
|
What is an array factor
: Why is it that the distances r1 and r2 in the phase factors in equations (8.47a) and (8.47b) cannot be set equal to r, but the same quantities in the amplitude factors can be set equal to r?
|
|
How a benefits program might increase worker attraction
: How important are benefits to you? Describe how a benefits program might increase worker attraction, retention, and motivation
|
|
Prepare the required common size income statements for ibm
: To create the required common size income statements for IBM, see the following resources: NetMBA (2010) Common Size Financial Statements Investigating AnswersUse total revenue for sales to construct these values.
|
|
Question regarding the regression analysis
: Calculate then explain/interpret the following 14 tasks/tests using the dependent variable (labeled Y)(Sales) and the independent variables (labeled X1 (Calls), X2 (Time), and X3(Years)). Attached is the excel Spreadsheet with the variables.
|
|
Create a swot analysis of usefulness of talent management
: Create a SWOT analysis of the usefulness of talent management in general. List the Strengths, Weaknesses, Opportunities and Threats (SWOT) that could propel an organization toward the creation of a specific method to identify and develop the talen..
|
|
What are you relying upon to draw your conclusions
: Discuss the basis of a breach of contract claim by College against Contractors, any potential damages College could claim and the likely outcome of a lawsuit.What are you relying upon to draw your conclusions (what facts and what laws)?
|
|
Distinguish between broadside and endfire radiation patterns
: Discuss the concept of unit and group patterns and their multiplication to obtain the resultant pattern of an array.
|
|
Explain the importance of hrm to any organization
: In your own words, explain the importance of HRM to any organization then determine a HRM function that interest you as a future career
|