Name your Microsoft Excel workbook SU_MBA5008_W5_A2 ...



The textbook is:Statistics for Management and Economics, Abbreviated Edition, 9th Edition Gerald KellerISBN-10: 1111527326ISBN-13: 9781111527327? 2012Assignment 3: Final ProjectIn 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.Assignment 3 Grading Criteria Maximum PointsSummarized the findings and drew conclusions.35Created a final report document containing the following: Executive summaryData and methodologyAnalytic details15Presented a structured document free of spelling and grammatical errors.5Cited all sources using the APA format.5Total:60Investigate How a Company Uses Data in MarketingSelect a company (maybe your employer) and assess how it uses data in marketing its products or services. (If it is not your employer, find a sizable local company or search the Internet for a company and contact the marketing department.) Specifically, address the following considerations:What data does the company capture and have available? What additional data does the company acquire from outside data vendors and why? What specific insights or information do companies hope to extract from the available data? How does the analysis of the data translate into decisions? Submit your answers in a 4- to 5-page Microsoft Word document.Name your document SU_MBA5008_W2_A2_LastName_FirstInitial.doc.Submit your document to this Discussion Area by Week 2, Day 4.By the end of the week, use this Discussion Area to critique the answers posted by at least two of your peers.Cite any sources using the APA format on a separate page.Assignment 2 Grading CriteriaMaximum PointsAnalyzed and explained the data the company captures and has available with itself.5Analyzed and justified the additional data the company acquires from outside data vendors. 5Discussed the specific insight or information companies hope to extract out of the available data.5Analyzed and explained how the data translates into decisions.5Participated in the discussion by asking a question, providing a statement of clarification, providing a point of view with rationale, challenging a point of discussion, or making a relationship between one or more points of the discussion as well as responding to at least two other posts.10Presented a structured document free of spelling and grammatical errors.5Properly cited sources using the APA format.5Total:40Assignment 3: ProblemsExercisesIn the exercises sections in the chapters, of your textbook, Statistics for Management and Economics, perform the following activities:"Probability": Exercises 6.75 and 6.81"Introduction to Estimation": Exercises 10.11 and 10.14"Introduction to hypothesis testing": Exercises 11.52 and 11.60"Inference about a population": Exercises 12.73 and 12.74Submit your answers in a 4- to 5-page Microsoft Word document and import any associated work in Microsoft Excel.Name your document SU_MBA5008_W2_A3_LastName_FirstInitial.doc.Submit your document to this W2: Assignment 3 Dropbox by Thursday, January 9, 2014.Cite any sources using the APA format on a separate page.Assignment 3 Grading Criteria Maximum PointsCompleted the exercises and imported the required data in Microsoft Excel for chapter 6.10Completed the exercises and imported the required data in Microsoft Excel for chapter 10.10Completed the exercises and imported the required data in Microsoft Excel for chapter 11.15Completed the exercises and imported the required data in Microsoft Excel for chapter 12.15Total:50Assignment 4: Final ProjectProbability and Hypothesis TestingYour 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 function-wise statistical analysis. The focus of your analysis will be on the marketing strategy 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 segment, you will estimate simple probability and test hypotheses using the provided SampleDataSet.Probability: Find the Region variable in the SampleDataSet. Using SampleDataSet, create a frequency distribution or a histogram. Based on the frequency distribution or histogram, estimate the probability associated with each region. Test the following hypotheses: Hypothesis 1: Age (of residents) of Region 1 > Age of Region 7 Hypothesis 2: Wealth score of mail donors ≥ Wealth score of mail nondonors Specify your hypothesis completely in terms of null and alternative; detail your findings and conclusions. Submit your answers in a 3- to 4-page Microsoft Word document.Name your document: SU_MBA5008_W2_A4_LastName_FirstInitial.doc.Submit your document to the W2: Assignment 4 Dropbox by Sunday, January 12, 2014.Cite any sources using the APA format on a separate page.Assignment 4 Grading Criteria Maximum PointsCreated a frequency distribution or a histogram. Based on the frequency distribution or histogram, estimated the probability associated with each region.25Tested the two hypotheses.10Specified the hypothesis completely in terms of null and alternative and detailed your findings and conclusions.15Presented a structured report free of spelling and grammatical errors.5Properly cited sources using the APA format.5Total:60Assignment 2: Midweek AssignmentYour instructor will assign you one of the topics for your assignment. Post your document to the appropriate Discussion Area by Week 3, Day 4. Review and critique the work of at least two other students by the end of the week.? ? Use the Respond link to post responses and materials that pertain to this assignment. Use the Respond link beneath any existing postings to respond to them. Select a topic from the menu below.Type I vs. Type II errorType I vs. Type II errorYou are a business analyst employed by a large database management and consulting organization. Your job entails analysis of the available data that tends to vary considerably across clients in terms of volume and quality, with the goal of previously unknown insights or validating currently-held beliefs. One of your concerns is the validity and reliability of your conclusions; hence you are always careful about Type I and Type II errors.Discuss the differences between Type I and Type II errors in the context of business decision making. Explain how each of the two types of errors can impact both, the validity as well as the reliability of conclusions? As a business analyst, what would you do to minimize the chances of either Type I or Type II errors adversely impacting your conclusions?Submit your answers in a 2- to 3-page Microsoft Word document.Name your document: SU_MBA5008_W3_A2_LastName_FirstInitial.doc.Submit your document to this Discussion Area by Week 3, Day 4.By the end of the week, use this Discussion Area to critique the answers posted by at least two of your peers.Cite any sources using the APA format on a separate page.Assignment 2 Grading Criteria Maximum PointsDiscussed the differences between Type I and Type II errors in the context of business decision making.10Explained how each of the two types of errors impact both, the validity as well as the reliability of conclusions.10Participated in the discussion by asking a question, providing a statement of clarification, providing a point of view with rationale, challenging a point of discussion, or making a relationship between one or more points of the discussion as well as responding to at least two other posts.10Presented a structured document free of spelling and grammatical errors.5Cited all sources using the APA format.5Total:40Assignment 3: ProblemsExercisesIn the exercises sections in the chapters, of your textbook, Statistics for Management and Economics, perform the following activities:"Random Variables and Discrete Probability Distributions": 7.84 and 7.97"Continuous Probability Distributions": 8.35 and 8.42"Inference about Comparing two Populations": 13.5 and 13.8"Chi-Squared Tests": 15.48 and 15.56Submit your answers in a 4- to 5-page Microsoft Word document and import any associated work in Microsoft Excel.Name your document SU_MBA5008_W3_A3_LastName_FirstInitial.doc.Submit your document to this W3: Assignment 3 Dropbox by Thursday, January 16, 2014.Cite any sources using the APA format on a separate page.Assignment 3 Grading Criteria Maximum PointsCompleted the exercises and imported the required data in Microsoft Excel for "Random Variables and Discrete Probability Distributions".10Completed the exercises and imported the required data in Microsoft Excel for "Continuous Probability Distributions".10Completed the exercises and imported the required data in Microsoft Excel for "Inference about Comparing two Populations".15Completed the exercises and imported the required data in Microsoft Excel for "Chi-Squared Tests".15Total:50Assignment 4: Final ProjectEstimationYour final project entails systematic extraction of decision-aiding insights out of a dataset (SampleDataSet.xlsx) provided to you in the Doc Sharing area.In this section, you will carry out the following basic estimation and tests of differences using the provided SampleDataSet.xlsx:Identify three continuous and three discrete variables and describe their distribution numerically (e.g., central tendency, spread) as well as graphically. Compare the results. Using the variables selected, conduct all possible t-tests and chi-squared tests. Describe your findings. In addition, discuss how data limitations (e.g., missing values, etc.) can affect the validity and reliability of statistical estimations and tests of differences. Be specific. Show your work using Microsoft Excel and import your work into a Microsoft Word document.Submit your response?with imported Microsoft Excel?work in a 3- to 4-page Microsoft Word document.Name your document SU_MBA5008_W3_A4_LastName_FirstInitial.doc.Submit your document to the W3: Assignment 4 Dropbox by Sunday, January 19, 2014.Cite any sources using the APA format on a separate page.Assignment 4 Grading Criteria Maximum PointsIdentified and described three continuous and three discrete variables and described their distribution numerically as well as graphically.20Described the findings after conducting all possible t-tests and chi-squared tests.20Discussed how data limitations can affect the validity and reliability of statistical estimation and tests of differences.10Presented a structured document free of spelling and grammatical errors.5Cited all sources using the APA format.5Total:60Regression ModelingUsing the XR17-07 dataset (in the data sets/Excel files directory of the CD accompanying your textbook) and Microsoft Excel, build and validate a multiple regression model. Explicitly describe the following:Choose the dependent as well as the independent variables. Why do you think are the selected independent variables expected to cause changes in the dependent variables?Assess the goodness of fit of your model.Interpret the coefficients of the regression model. Which independent variable has the strongest impact on the dependent variables? Which independent variable has the weakest impact?Summarize the key business takeaways from your model. Briefly describe what the model communicates.Submit your response in a 2- to 3-page Microsoft Word document (copying any supporting parts of the Microsoft Excel output).Name your document SU_MBA5008_W4_A2_LastName_FirstInitial.doc.Submit your document to the W4: Assignment 2 Dropbox by Week 4, Day 4.Cite any sources using the APA format on a separate page.Assignment 2 Grading Criteria Maximum PointsExplained why the selected independent variables are expected to cause changes in the dependent variables.5Assessed the goodness of fit of your model.5Explained which independent variable has the strongest impact on the dependent variables and which one has the weakest.10Summarized the key business takeaways from your model.10Presented a structured document free of spelling and grammatical errors.5Cited all sources using the APA format.5Total:40Assignment 3: ProblemsExercisesFrom 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 3 Grading Criteria Maximum PointsCompleted the exercises for "Simple Linear Regression and Correlation" in Microsoft Excel.20Completed the exercises for "Multiple Regression" in Microsoft Excel.30Total:50Assignment 4: Final ProjectOngoing Data ExplorationYour 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.Assignment 4 Grading Criteria Maximum PointsComputed a correlation matrix that includes all continuous variables.15Identified all individual correlations that are significant at the 95 percent level.10Described the goodness of fit of your model and summarized your findings.15Selected at least four to seven or similar independent variables from the remaining forty-nine measures and justified your selection.10Presented a structured document free of spelling and grammatical errors.5Cited all sources using the APA format.5Total:60Assessing the Quality of Regression ResultsConsider 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 VariablesUnstandardized CoefficientsStandardized CoefficientstSig.BStd. ErrorBeta(Constant).991.106?9.362.000Variable 1.045.101.015.445.657Variable 2-.051.084-.020-.607.544Variable 3.299.107.0622.786.005Variable 4-.341.329-.023-1.039.299Variable 5.000.000-.011-.284.776Variable 6.000.000.009.251.802Variable 7.000.000-.011-.264.792Variable 8.000.000-.001-.022.983Variable 9-.003.005-.015-.704.482Variable 10.031.036.019.870.384Variable 11-.023.041-.013-.558.577Variable 12-.001.011-.003-.117.907Variable 13.000.000.0502.310.021Variable 14.003.000.1456.631.000Variable 15.000.000-.008-.380.704Variable 16.053.016.0753.403.001Variable 17.006.014.430.458.647Variable 18-.006.013-.425-.450.653Variable 19-.136.156-.019-.869.385Write 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 2 Grading Criteria Maximum PointsIdentified all statistically significant predictors and which variable has the strongest impact.15Explained the interpretation of the “constant” term.15Presented a structured document free of spelling and grammatical errors.5Cited all sources using the APA format.5Total:40Business ForecastingFrom 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.Assignment 2 Grading Criteria Maximum PointsPlotted the time series accurately.5Discussed why exponential smoothing is not recommended as a forecasting tool in situation.?????????? 5Used regression analysis to determine the trend line.?????????? 5Determined the seasonal indexes accurately.?????????? 5Accurately forecasted revenues for the next four quarters.10Presented a structured document free of spelling and grammatical errors.5Cited all sources using the APA format.5Total:40Assignment 3: ProblemsExercisesFrom 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 3 Grading Criteria Maximum PointsCompleted the exercises for "Multiple Regression" and imported the required data in a Microsoft Excel workbook.25Completed the exercises for?"Time-Series Analysis and Forecasting" and imported the required data in a Microsoft Excel workbook.25Total:50Assignment 4: Final ProjectOngoing Data ExplorationYour 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 4 Grading Criteria Maximum PointsUsed the multiple regression model created in Week 4 and provided a thorough assessment of your model's diagnostics.10Identified all relevant assessment dimensions.10Briefly outlined the purpose and importance of the assessment dimensions.10Provided an assessment of your model in terms of the identified diagnostic measures. 10Presented a structured document free of spelling and grammatical errors.5Demonstrated an understanding of the purpose of each diagnostic.15Total:60Assignment 2: ProblemsExercisesFrom your textbook, Statistics for Management and Economics, complete the following exercises:"Decision Analysis": Exercises 22.2 and 22.11Write 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.Assignment 2 Grading Criteria Maximum PointsCompleted the exercises for "Decision Analysis" and imported the required data in Microsoft Excel workbook.10Correctly completed exercise 22.2.????????? 20Correctly completed exercise 22.11.??????????20Total:50Assignment 3: Final ProjectIn 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.Assignment 3 Grading Criteria Maximum PointsSummarized the findings and drew conclusions.35Created a final report document containing the following: Executive summaryData and methodologyAnalytic details15Presented a structured document free of spelling and grammatical errors.5Cited all sources using the APA format.5Total:60 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download