Analyzing Real-World Business Situation Using Regression

This task is one, but first I have to complete Task 1 Template and get approval from my school to before I can proceed. Kindly go through the documents and the attachedment and fill out the cho
TASK 1
DATA-DRIVEN DECISION MAKING — C207
TASK OVERVIEWSUBMISSIONSEVALUATION REPORT
COMPETENCIES
________________________________________
3009.1.1 : The Case for Quantitative Analysis
The graduate uses decision-making methods to develop strategies for organizational decision processes.
3009.1.2 : Statistics as a Managerial Tool
The graduate uses a variety of decision-analysis tools to evaluate alternatives during the decision-making processes.
3009.1.3 : More Statistical Tools
The graduate uses quantitative techniques and statistical tools to identify the most appropriate decision alternatives.
3009.1.4 : Quality Metrics and Tools
The graduate analyzes how work is accomplished and applies quality metrics and tools to increase efficiency, effectiveness, and quality.
3009.1.5 : Real World Data-Driven Decisions
The graduate analyzes data from business intelligence and knowledge-management systems to make appropriate decisions.
3009.1.6 : Improving Organization Performance
The graduate uses appropriate data to improve organizational performance.
INTRODUCTION
_____________________________________
In this task, you will identify a real-world business situation and use real data to perform a data analysis leading to an actionable recommendation. You are encouraged to select an issue in your workplace or program specialty area (e.g., IT management, HC management, or MBA). Publicly available data is also an option (see Course Tips).
Note: Work performed for a client or an employer is their property and should not be used without written permission. Fictionalize identifiable organizational information (i.e., make up information regarding the identity of the organization, but do not make up the data). Obtain written permission to use any information that would be considered confidential, proprietary, or personal in nature. To obtain an organization’s permission to use proprietary information, complete and submit the attached “Organization Verification Form.”
This business situation and data will be used to complete task 2. Do not work on task 2 until you have successfully passed task 1, indicating that the business situation and data analysis plan have been approved.
Use the “Determining the Appropriate Analytical Technique” presentation in the Attachment section below and/or speak with a course instructor to help you identify the appropriate analysis technique to analyze data for these tasks.
Approved data analysis techniques include the following:
Recommended Analysis Techniques:
• regression (linear regression, multiple regression, or logistic regression)
• time series or trend analysis
Note: you need to specify the specific type(s) of time-series analysis you plan to use or consider in Task 2 – i.e., regression, exponential smoothing, moving average, seasonality using multiple regression
• chi-square
• t-test (one sample, two independent samples, or paired)
• ANOVA
• crossover analysis
• break-even analysis
Additional Approved Analysis Techniques:
• statistical process control
• linear programming
• decision tree
• simulation
SCENARIO
____________________________________
REQUIREMENTS________________________________________
Your submission must be your original work. No more than a combined total of 30% of the submission and no more than a 10% match to any one individual source can be directly quoted or closely paraphrased from sources, even if cited correctly. The originality report that is provided when you submit your task can be used as a guide.
You must use the rubric to direct the creation of your submission because it provides detailed criteria that will be used to evaluate your work. Each requirement below may be evaluated by more than one rubric aspect. The rubric aspect titles may contain hyperlinks to relevant portions of the course.
Tasks may not be submitted as cloud links, such as links to Google Docs, Google Slides, OneDrive, etc., unless specified in the task requirements. All other submissions must be file types that are uploaded and submitted as attachments (e.g., .docx, .pdf, .ppt).
Use the attached “Task 1 Template” to complete the following prompts:
A. Describe a real-world business situation that could be addressed by collecting and analyzing a set of data.
Note: The data can be from your workplace, from publicly available sources, or primary data that you collect on your own (e.g., a survey or behavioral observations).
1. Complete the “Project Waiver or Release Statement” by putting a check mark in one of the checkboxes in the attached Task 1 Template.
a. If you select the second option, “My project is based upon and/or includes Restricted Information”, You must complete the attached “Organization Verification Form”. You need to complete page 1 first and then submit the entire document to your chosen organization. The organization must complete page 2 and provide you with a completed form. You’ll submit the completed “Organization Verification Form” as a separate attachment with Task 1 template. See the attached “Electronic Signature Instruction” for instructions on how to electronically sign the attached “Organization Verification Form.” This form is not published and will remain confidential. The organization’s name should be used on this form but can be changed to a fictional name for the remaining tasks.
2. Summarize one question or decision relevant to the real-world business situation that you will answer by collecting and analyzing a set of data.
3. Explain why the situation or question would benefit from a data analysis.
4. Identify all of the data that you will need to collect that is relevant to the situation or question.
Note: Identify the specific data relevant to part B1, such as time period, sample size, etc.
Note: A sample size of 30 is the suggested minimum size.
5. Describe the data gathering method you will use to collect data.
Note: The data gathering method can include data sources (e.g., databases, surveys, behavioral observations, online sources, etc.)
6. Identify an appropriate data analysis technique from the approved list above to analyze this data.
a. Explain why the data analysis technique you chose is an appropriate technique to analyze the data collected.
Note: Use the “Determining the Appropriate Analytical Technique” presentation in the Attachment section below to help you determine the appropriate analysis technique for your data and business situation or speak with a course instructor.
B. Acknowledge sources, using in-text citations and references, for content that is quoted, paraphrased, or summarized.
C. Demonstrate professional communication in the content and presentation of your submission.
File Restrictions
File name may contain only letters, numbers, spaces, and these symbols: ! - _ . * ' ( )
File size limit: 200 MB
File types allowed: doc, docx, rtf, xls, xlsx, ppt, pptx, odt, pdf, txt, qt, mov, mpg, avi, mp3, wav, mp4, wma, flv, asf, mpeg, wmv, m4v, svg, tif, tiff, jpeg, jpg, gif, png, zip, rar, tar, 7z
RUBRIC
_____________________________________
A:REAL-WORLD BUSINESS SITUATION:
NOT EVIDENT
The candidate does not describe a real-world business situation that could be addressed by collecting and analyzing a set of data. APPROACHING COMPETENCE
The candidate describes, with insufficient detail, a real-world business situation that could be addressed by collecting and analyzing a set of data. COMPETENT
The candidate describes, with sufficient detail, a real-world business situation that could be addressed by collecting and analyzing a set of data.
A1:WAIVER-RELEASE FORM:
NOT EVIDENT
The candidate does not select Waiver or Release Statement. APPROACHING COMPETENCE
Not applicable COMPETENT
The candidate selects Waiver or Release Statement.
A1A:ORGANIZATION VERIFICATION FORM:
NOT EVIDENT
The candidate does not provide a completed Organization Verification Form and the Organization Verification Form is necessary as indicated by the Waiver-Release Form. APPROACHING COMPETENCE
Not applicable. COMPETENT
The candidate provides a completed Organization Verification Form or the Organization Verification Form is not necessary as indicated by the Waiver-Release Form.
A2:SUMMARY OF ONE QUESTION OR DECISION:
NOT EVIDENT
The candidate does not provide a logical summary of 1 question or decision relevant to the real-world business situation that the candidate will answer by collecting and analyzing a set of data. APPROACHING COMPETENCE
The candidate provides a logical summary, with insufficient detail, of 1 question or decision relevant to the real-world business situation that the candidate will answer by collecting and analyzing a set of data. COMPETENT
The candidate provides a logical summary, with sufficient detail, of 1 question or decision relevant to the real-world business situation that the candidate will answer by collecting and analyzing a set of data.
A3:EXPLANATION OF SITUATION:
NOT EVIDENT
The candidate does not provide a logical explanation of why the situation or question would benefit from a data analysis. APPROACHING COMPETENCE
The candidate provides a logical explanation, with insufficient support, of why the situation or question would benefit from a data analysis. COMPETENT
The candidate provides a logical explanation, with sufficient support, of why the situation or question would benefit from a data analysis.
A4:DATA TO COLLECT:
NOT EVIDENT
The candidate does not identify data that will need to be collected. APPROACHING COMPETENCE
The candidate identifies data that will need to be collected but the data is not relevant to the situation or question. COMPETENT
The candidate identifies data that will need to be collected that is relevant to the situation or question.
A5:DATA GATHERING METHOD:
NOT EVIDENT
The candidate does not provide an appropriate description of the data gathering method the candidate will use to collect data. APPROACHING COMPETENCE
The candidate provides an appropriate description, with insufficient detail, of the data gathering method the candidate will use to collect data. COMPETENT
The candidate provides an appropriate description, with sufficient detail, of the data gathering method the candidate will use to collect data.
A6:DATA ANALYSIS TECHNIQUE:
NOT EVIDENT
The candidate does not identify a data analysis technique that will be used to analyze the data. APPROACHING COMPETENCE
The candidate identifies a data analysis technique that is not appropriate and/or not approved to be used to analyze the data. COMPETENT
The candidate identifies an appropriate and approved data analysis technique that will be used to analyze the data.
A6A:EXPLANATION OF TECHNIQUE:
NOT EVIDENT
The candidate does not provide a logical explanation of why the data analysis technique chosen is an appropriate technique to analyze the data collected. APPROACHING COMPETENCE
The candidate provides a logical explanation, with insufficient support, of why the data analysis technique chosen is an appropriate technique to analyze the data collected. COMPETENT
The candidate provides a logical explanation, with sufficient support, of why the data analysis technique chosen is an appropriate technique to analyze the data collected.
B:SOURCES
NOT EVIDENT
The submission does not include both in-text citations and a reference list for sources that are quoted, paraphrased, or summarized. APPROACHING COMPETENCE
The submission includes in-text citations for sources that are quoted, paraphrased, or summarized and a reference list; however, the citations or reference list is incomplete or inaccurate. COMPETENT
The submission includes in-text citations for sources that are properly quoted, paraphrased, or summarized and a reference list that accurately identifies the author, date, title, and source location as available.
C:PROFESSIONAL COMMUNICATION
NOT EVIDENT
Content is unstructured, is disjointed, or contains pervasive errors in mechanics, usage, or grammar. Vocabulary or tone is unprofessional or distracts from the topic. APPROACHING COMPETENCE
Content is poorly organized, is difficult to follow, or contains errors in mechanics, usage, or grammar that cause confusion. Terminology is misused or ineffective. COMPETENT
Content reflects attention to detail, is organized, and focuses on the main ideas as prescribed in the task or chosen by the candidate. Terminology is pertinent, is used correctly, and effectively conveys the intended meaning. Mechanics, usage, and grammar promote accurate interpretation and understanding.
SUPPORTING DOCUMENTS
______________________________________
Electronic Signature Instructions.docx
Organization Verification Form.pdf
Task 1 Template.docx
Determining_Appropriate_Analysis_Technique.pptx
Above four pdf is attached.
TASK 2
DATA-DRIVEN DECISION MAKING — C207
TASK OVERVIEWSUBMISSIONSEVALUATION REPORT
COMPETENCIES
_____________________________________
3009.1.1 : The Case for Quantitative Analysis
The graduate uses decision-making methods to develop strategies for organizational decision processes.
3009.1.2 : Statistics as a Managerial Tool
The graduate uses a variety of decision-analysis tools to evaluate alternatives during the decision-making processes.
3009.1.3 : More Statistical Tools
The graduate uses quantitative techniques and statistical tools to identify the most appropriate decision alternatives.
3009.1.4 : Quality Metrics and Tools
The graduate analyzes how work is accomplished and applies quality metrics and tools to increase efficiency, effectiveness, and quality.
3009.1.5 : Real World Data-Driven Decisions
The graduate analyzes data from business intelligence and knowledge-management systems to make appropriate decisions.
3009.1.6 : Improving Organization Performance
The graduate uses appropriate data to improve organizational performance.
INTRODUCTION
________________________________________
In this task, you will address the real-world business situation that you identified in task 1. Using relevant data you have gathered, analyze the data and recommend a solution. This recommendation will be included in a report that you will write, summarizing the key details of your analysis.
Note: You must successfully pass task 1 before work on task 2 is started.
Approved data analysis techniques for this task include the following:
Recommended Analysis Techniques:
• regression (linear regression, multiple regression, or logistic regression)
• time series or trend analysis (regression, exponential smoothing, or moving average)
• chi-square
• t-test
• ANOVA
• crossover analysis
• break-even analysis
Additional Approved Analysis Techniques:
• statistical process control
• linear programming
• decision tree
• simulation
REQUIREMENTS________________________________________
Your submission must be your original work. No more than a combined total of 30% of the submission and no more than a 10% match to any one individual source can be directly quoted or closely paraphrased from sources, even if cited correctly. The originality report that is provided when you submit your task can be used as a guide.
You must use the rubric to direct the creation of your submission because it provides detailed criteria that will be used to evaluate your work. Each requirement below may be evaluated by more than one rubric aspect. The rubric aspect titles may contain hyperlinks to relevant portions of the course.
Create a report (suggested length of 2–4 written pages or 800 words) by doing the following:
A. Summarize the real-world business situation you identified in task 1.
B. Report the data you collected, relevant to the business situation, by doing the following:
1. Describe the relevant data you collected.
2. Create an appropriate graphical display (e.g., bar chart, scatter plot, line chart, or histogram) of the data you collected.
Note: This display should be a summary or representation of your data, not raw data.
C. Report how you analyzed the data using an analysis technique from the given list by doing the following:
1. Describe an appropriate analysis technique that you used to analyze the data.
2. Include the output and any calculations of the analysis you performed.
Note: The output should include the output from the software you used to perform the analysis. Refer to “Prepare for the Performance Assessment Task 2” in the course of study to see examples of acceptable output.
3. Justify why you chose this analysis technique.
D. Summarize the implications of your data analysis by doing the following:
1. Discuss the results of your data analysis.
Note: Refer “Prepare for the Performance Assessment Task 2” in the course of study to see an example of an acceptable discussion of results.
2. Discuss the limitation(s) of your data analysis.
3. Recommend a course of action based on your results.
Note: Your recommendation should focus on the results of your analytic technique output from part C2.
E. Acknowledge sources, using in-text citations and references, for content that is quoted, paraphrased, or summarized.
F. Demonstrate professional communication in the content and presentation of your submission.
File Restrictions
File name may contain only letters, numbers, spaces, and these symbols: ! - _ . * ' ( )
File size limit: 200 MB
File types allowed: doc, docx, rtf, xls, xlsx, ppt, pptx, odt, pdf, txt, qt, mov, mpg, avi, mp3, wav, mp4, wma, flv, asf, mpeg, wmv, m4v, svg, tif, tiff, jpeg, jpg, gif, png, zip, rar, tar, 7z
RUBRIC
________________________________________
A:SUMMARY OF SITUATION:
NOT EVIDENT
The candidate does not provide a logical summary of the real-world business situation identified in task 1. APPROACHING COMPETENCE
The candidate provides a logical summary, with insufficient detail, of the real-world business situation identified in task 1. COMPETENT
The candidate provides a logical summary, with sufficient detail, of the real-world business situation identified in task 1.
B1:SUMMARY OF DATA:
NOT EVIDENT
The candidate does not provide an appropriate description of the relevant data the candidate collected. APPROACHING COMPETENCE
The candidate provides an appropriate description, with insufficient detail, of the relevant data the candidate collected, OR the data is not relevant. COMPETENT
The candidate provides an appropriate description, with sufficient detail, of the relevant data the candidate collected.
B2:GRAPHICAL DISPLAY:
NOT EVIDENT
The candidate does not provide a graphical display of the data collected. APPROACHING COMPETENCE
The candidate provides an inappropriate and/or incorrect graphical display of the data collected. COMPETENT
The candidate provides an appropriate and correct graphical display of the data collected.
C1:DESCRIPTION OF ANALYSIS TECHNIQUE:
NOT EVIDENT
The candidate does not provide a description of an appropriate analysis technique used to analyze the data. APPROACHING COMPETENCE
The candidate provides a description, with insufficient detail, of the analysis technique used to analyze the data, OR the analysis technique is not appropriate and/or not approved. COMPETENT
The candidate provides a description, with sufficient detail, of an appropriate and approved analysis technique used to analyze the data.
C2:OUTPUT AND CALCULATIONS:
NOT EVIDENT
The candidate does not include the output or any calculations of the analysis performed. APPROACHING COMPETENCE
The candidate includes incorrect output or calculations of the analysis performed. COMPETENT
The candidate includes correct output and any calculations of the analysis performed.
C3:JUSTIFICATION OF ANALYSIS TECHNIQUE:
NOT EVIDENT
The candidate does not provide a logical justification of why the analysis technique was chosen. APPROACHING COMPETENCE
The candidate provides a logical justification, with insufficient support, of why the analysis technique was chosen. COMPETENT
The candidate provides a logical justification, with sufficient support, of why the analysis technique was chosen.
D1:DATA ANALYSIS RESULTS:
NOT EVIDENT
The candidate does not provide a logical discussion of the results of the candidate’s data analysis. APPROACHING COMPETENCE
The candidate provides a logical discussion, with insufficient detail, of the results of the candidate’s data analysis. COMPETENT
The candidate provides a logical discussion, with sufficient detail, of the results of the candidate’s data analysis.
D2:DATA ANALYSIS LIMITATIONS:
NOT EVIDENT
The candidate does not provide a logical discussion of the limitations of the candidate’s data analysis. APPROACHING COMPETENCE
The candidate provides a logical discussion, with insufficient detail, of the limitations of the candidate’s data analysis. COMPETENT
The candidate provides a logical discussion, with sufficient detail, of the limitations of the candidate’s data analysis.
D3:RECOMMENDED COURSE OF ACTION:
NOT EVIDENT
The candidate does not provide a plausible recommendation for a course of action based on the candidate’s results. APPROACHING COMPETENCE
The candidate provides a plausible recommendation, with insufficient support, for a course of action based on the candidate’s results. COMPETENT
The candidate provides a plausible recommendation, with sufficient support, for a course of action based on the candidate’s results.
E:SOURCES
NOT EVIDENT
The submission does not include both in-text citations and a reference list for sources that are quoted, paraphrased, or summarized. APPROACHING COMPETENCE
The submission includes in-text citations for sources that are quoted, paraphrased, or summarized and a reference list; however, the citations or reference list is incomplete or inaccurate. COMPETENT
The submission includes in-text citations for sources that are properly quoted, paraphrased, or summarized and a reference list that accurately identifies the author, date, title, and source location as available.
F:PROFESSIONAL COMMUNICATION
NOT EVIDENT
Content is unstructured, is disjointed, or contains pervasive errors in mechanics, usage, or grammar. Vocabulary or tone is unprofessional or distracts from the topic. APPROACHING COMPETENCE
Content is poorly organized, is difficult to follow, or contains errors in mechanics, usage, or grammar that cause confusion. Terminology is misused or ineffective. COMPETENT
Content reflects attention to detail, is organized, and focuses on the main ideas as prescribed in the task or chosen by the candidate. Terminology is pertinent, is used correctly, and effectively conveys the intended meaning. Mechanics, usage, and grammar promote accurate interpretation and understanding.
SUPPORTING DOCUMENTS
_______________________________________
Determining_Appropriate_Analysis_Technique.pptx - This Pdf is attached.
=================
From the Client
Regression will be my choice. Any one that involve statistical date.