Need Assistance with these problems.

profiletls18

Hi A-Z Answers:

 

Here are the assignments and the associated due dates:

 

Assignment 3: Problems

Exercises

From your textbook, Statistics for Management and Economics, complete the following exercises:

 

"Simple Linear Regression and Correlation": Exercises 16.1, 16.7, 16.28, and 16.100

"Multiple Regression": Exercises 17.2 and 17.5

 

Submit your answers in a Microsoft Excel workbook, with each problem on a separate worksheet. Label each tab in the workbook with the exercise number. Highlight the answers in yellow and provide an interpretation in a text box.

Name your Microsoft Excel workbook SU_MBA5008_W4_A3_LastName_FirstInitial.xls.

Submit your workbook to this W4: Assignment 3 Dropbox by Friday, January 24, 2014.

Cite any sources using the APA format on a separate page.

 

Assignment 4: Final Project

Ongoing Data Exploration

Your final project entails systematic extraction of decision-aiding insights from a dataset (SampleDataSet.xlsx) provided to you in the Doc Sharing area. The goal of this project is to provide you with hands-on experience in conducting and interpreting different types of statistical analysis. The focus of your analysis will be on marketing strategies and analysis-related topics. At times, you will be expected to conduct additional research on topics that are not adequately covered in your text, for example, data due diligence.

In this section, you will conduct correlation and regression analyses using the provided SampleDataSet.xlsx.

  • Correlation: Compute a correlation matrix that includes all continuous variables. Identify all individual correlations that are significant at the 95 percent level.
  • Regression: Build a multiple regression model to explain the variability in the median school year. Describe the goodness of fit of your model and summarize your findings. Select at least four to seven similar independent variables from the remaining forty-nine measures and justify your selection.

Submit your response in Microsoft Excel.

Name your worksheet SU_MBA5008_W4_A4_LastName_FirstInitial.xls.

Submit your worksheet to the W4: Assignment 4 Dropbox by Sunday, January 26, 2014.

Cite any sources using the APA format on a separate page.

 

Assessing the Quality of Regression Results

Consider the following multiple regression results. Using a= .05 as the significance level, identify all statistically significant predictors.  In a relative sense, which variable has the strongest impact?  What is the interpretation of the “constant” term?

Independent Variables
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
B
Std. Error
Beta
(Constant)
.991
.106
 
9.362
.000
Variable 1
.045
.101
.015
.445
.657
Variable 2
-.051
.084
-.020
-.607
.544
Variable 3
.299
.107
.062
2.786
.005
Variable 4
-.341
.329
-.023
-1.039
.299
Variable 5
.000
.000
-.011
-.284
.776
Variable 6
.000
.000
.009
.251
.802
Variable 7
.000
.000
-.011
-.264
.792
Variable 8
.000
.000
-.001
-.022
.983
Variable 9
-.003
.005
-.015
-.704
.482
Variable 10
.031
.036
.019
.870
.384
Variable 11
-.023
.041
-.013
-.558
.577
Variable 12
-.001
.011
-.003
-.117
.907
Variable 13
.000
.000
.050
2.310
.021
Variable 14
.003
.000
.145
6.631
.000
Variable 15
.000
.000
-.008
-.380
.704
Variable 16
.053
.016
.075
3.403
.001
Variable 17
.006
.014
.430
.458
.647
Variable 18
-.006
.013
-.425
-.450
.653
Variable 19
-.136
.156
-.019
-.869
.385

Write your analysis in a 3- to 4-page Microsoft Word document.

Name your document SU_MBA5008_W5_A2_LastName_FirstInitial.doc.

Submit your analysis to the W5: Assignment 2 Dropbox by Week 5, Day 4.

Cite any sources using the APA format on a separate page.

 

Assignment 3: Problems

Exercises

From your textbook, Statistics for Management and Economics, complete the following exercises:

  • "Multiple Regression": Exercises 17.39, and 17.42
  • "Time-Series Analysis and Forecasting": Exercises 20.19 and 20.35

Submit your answers in a Microsoft Excel workbook, with each problem on a separate worksheet. Label each tab in the workbook with the exercise number. Highlight the answers in yellow and provide an interpretation in a text box.

Name your Microsoft Excel workbook SU_MBA5008_W5_A3_LastName_FirstInitial.xls.

Submit your workbook to this W5: Assignment 3 Dropbox by Friday, January 31, 2014.

Cite any sources using the APA format on a separate page.

 

Assignment 4: Final Project

Ongoing Data Exploration

Your final project entails systematic extraction of decision-aiding insights from a dataset (SampleDataSet.xlsx) provided to you in the Doc Sharing area. The goal of this project is to provide you with hands-on experience in conducting and interpreting different types of statistical analysis. The focus of your analysis will be on marketing strategies and analysis-related topics. At times, you will be expected to conduct additional research on topics that are not adequately covered in your text, for example, data due diligence.

In the Week 4 assignment, you were asked to build a multiple regression model to explain the variability in the median school year, using a minimum of seven independent variables. Using the same model, thoroughly assess your model's diagnostics. Identify all relevant assessment dimensions, briefly outline their purpose and importance, and provide an assessment of your model in terms of the identified diagnostic measures.

Submit your response in a 2- to 3-page Microsoft Word document to the W5: Assignment 4 Dropbox by Sunday, February 2, 2014.

Name your document SU_MBA5008_W5_A4_LastName_FirstInitial.doc.

Cite any sources using the APA format on a separate page.

 

Assignment 2: Problems

Exercises

From your textbook, Statistics for Management and Economics, complete the following exercises:

"Decision Analysis": Exercises 22.2 and 22.11

Write your answers in a Microsoft Excel workbook, with each problem on a separate worksheet. Label each tab in the workbook with the exercise number. Highlight the answers in yellow and provide an interpretation in a text box.

Name your Microsoft Excel workbook SU_MBA5008_W6_A2_LastName_FirstInitial.xls.

Submit your workbook to this W6: Assignment 2 Dropbox by Wednesday, February 5, 2014.

Cite any sources using the APA format on a separate page.

 

In the previous weeks, you used the sample dataset (SampleDataSet.xlsx) provided to you in the Doc Sharing area so as to conduct various analyses. This is similar to providing business analytics support on an ongoing basis and entails answering (by means of analysis) many different questions.

Summarize your findings and draw conclusions. Create a final report document containing the following:

  • Executive summary: This section should be a 1-page summary of the most important findings presented in the context of the recommended course of action.
  • Data and methodology: In this section, describe the characteristics of the data and the specific methodologies used in the analysis.
  • Analytic details: This section should contain supporting evidence for the findings and conclusions presented in the executive summary section.

Create your report in a 3- to 4-page Microsoft Word document.

Name your report SU_MBA5008_W6_A3_LastName_FirstInitial.doc.

Submit your report to the W6: Assignment 3 Dropbox by Wednesday, February 5, 2014.

Cite any sources using the APA format on a separate page.

 

Business Forecasting

From your textbook, Statistics for Management and Economics, complete the following exercises:

 

“Time Series Analysis and Forecasting”: Exercises 20.47, 20.48, 20.49, 20.50, and 20.51

 

Submit your answers in a Microsoft Excel workbook, with each problem on a separate worksheet. Label each tab in the workbook with the exercise number. Highlight the answers in yellow and provide an interpretation in a text box.

Name your Microsoft Excel workbook SU_MBA5008_W5_A2_LastName_FirstInitial.xls.

 

Submit your workbook to the W5: Assignment 2 Dropbox by Week 5, Day 4.

Cite any sources using the APA format on a separate page.

  • 10 years ago
  • 20
Answer(1)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    mba5008_week_3_assignment_3_weekly_problems.zip
  • attachment
    mba5008_week_4_assignment_3_weekly_problems.xlsx
  • attachment
    mba5008_week_5_assignment_3_weekly_problems.zip
  • attachment
    mba5008_week_6_assignment_2_exercises.xlsx