Description
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
<CAE = 1/2(115 - 63) = 1/2(52) = 26 Choice A
-------------------------------------------------------------------------------
Completion Status:
100%
Review
Review
Anonymous
Great study resource, helped me a lot.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
IRP project
1 Draft IRPSummary:In the Independent Research Project (IRP), students conduct an analysis project using SAS primarily and ...
IRP project
1 Draft IRPSummary:In the Independent Research Project (IRP), students conduct an analysis project using SAS primarily and Excel as needed to analyze real-world data.In the first assignment (IRP Research Question and Data Set), you identified the data set you wanted to use, developed a research question, and identified a statistical question that could be answered analytically.In this assignment, you will create and submit a business memo (template attached) that clearly communicates your analysis of the data set you identified in the previous assignment. When you submit this draft of your IRP, you will get feedback from your classmates and your instructor. You should use this feedback to improve your IRP.In later assignments (IRP Memorandum, IRP Presentation, Presentation Questions Reply), you will submit the final version of your IRP, create and submit a PowerPoint presentation that summarizes your IRP, present your analysis via a recorded video presentation, and answer questions about your presentation.AttachmentsIRP Template 2018.docxIRP Draft (2)CriteriaRatingsPtsThis criterion is linked to a Learning OutcomeUse of software tools10.0 ptsGood8.0 ptsFair0.0 ptsInadequate10.0 ptsThis criterion is linked to a Learning OutcomeData Display15.0 ptsGood12.0 ptsFair0.0 ptsInadequate15.0 ptsThis criterion is linked to a Learning OutcomeAnalysis Procedure25.0 ptsGood20.0 ptsFair0.0 ptsInadequate25.0 ptsThis criterion is linked to a Learning OutcomeData Analysis Conclusion20.0 ptsGood16.0 ptsFair0.0 ptsInadequate20.0 ptsThis criterion is linked to a Learning OutcomeRecommended Actions20.0 ptsGood16.0 ptsFair0.0 ptsInadequate20.0 ptsThis criterion is linked to a Learning OutcomeDecision Approach10.0 ptsGood8.0 ptsFair0.0 ptsInadequate10.0 ptsTotal Points: 100.02 IRP PresentationUpload your IRP PowerPoint presentation to this assignment.You only have four minutes, so be concise and careful with your language.Use the PowerPoint Narration tool for your slides, even if you present face to face, it is good practice.Attachments: IRP Presentation TemplateIS 3310 Presentation Rubric Fall 2018 v2CriteriaRatingsPtsThis criterion is linked to a Learning OutcomeContentInformation on slides reflects understanding and effective summarization. Information has not simply been copied and pasted from another IRP memo. Information is presented in logical sequence/structure.60.0to >35.0 ptsGoodAll essential elements needed to explain the analyiss and decision are present.35.0to >10.0 ptsAdequateMissing an essential element that explains the analysis and recommendation.10.0to >0 ptsInadequateTwo or more essential elements needed to understand the analysis are missing.60.0ptsThis criterion is linked to a Learning OutcomeDesignEasy to read, good color choices, no eye charts. Appropriate use of charts, graphs, and images to effectively communicate to the audience.15.0to >13.0 ptsGoodGreat design, color choice. Appropriate charts, graphs, tables, etc. are used in the presentation to promote the narrative.13.0to >10.0ptsAdequateSome charts, graphs, tables, etc. are used in the presentation to promote the narrative.10.0to >0 ptsInadequatePoor use of images, tables, etc. to explain the analysis and recommendation.15.0ptsThis criterion is linked to a Learning OutcomeUse of language (Grammar and Word Choice)Presentation is free of spelling and grammatical errors10.0 ptsGoodNo noticeable errors apparent in the presentation.10.0to >0 ptsInadequateOne ore more grammar, spelling, or obvious factual errors that a good proofreading of the presentation should have caught.10.0ptsThis criterion is linked to a Learning OutcomePresentationPresenter spoke clearly and slowly enough to be heard by the audience. Presenter effectively communicated their recommendation based on their analysis.15.0 ptsVery good.Clear, well spoken, not rushed. Presenation was organized logically, and effectively communicated the presenter's recommendation.10.0 ptsAveragePresenation was understandable, but was rushed and not logically arranged.5.0 ptsCould be betterThe speaker was hard to understand, rushed through the presentation, are had annoying habits that made following the15.0pts3 IRP MemorandumIn this Independent Research Project (IRP), students provide a business decision recommendation using SAS primarily and Excel as needed to obtain real world data. The student will create and submit a business report that clearly communicates a recommendation based on their analysis of the data set that includes an analysis of different courses of action using weighted factors. The students will also create a Power Point presentation that summarizes their IRP and present their analysis live, via video-teleconference or as a recorded video presentation. The student will also answer questions about their presentation.DELIVERABLE:ATTACH:IRP MEMORANDUM TEMPLATEIRP Memo Final (3)IRP Memo Final (3)CriteriaRatingsPtsThis criterion is linked to a Learning OutcomeSalutationIdentify the audience for this IRP3.0 ptsGoodDate, From, To lines correct.1.0 ptsFairOne or more items incorrect.0.0 ptsInadequateTwo or more items incorrect.3.0 ptsThis criterion is linked to a Learning OutcomeSubject LineShould relate to the topic, be interesting.3.0 ptsGoodSubject line is relevant and informative.1.0 ptsFairSubject line is not relevant to the IRP.0.0 ptsInadequateSubject line does is not informative.3.0 ptsThis criterion is linked to a Learning OutcomeIntroductionSummary of the whole IRP. You may not be able to write this portion until you have finished the rest of the paper.26.0 ptsGoodParagraph 1: Summary of IRP. Paragraph 2: Discussion of tools and data. Paragraph 3: Summary of findings, analysis conclusion, and recommendation.16.0 ptsFairMissing one of the introduction paragraphs, or not well written.5.0 ptsInadequateMissing two or more of the relevant parts of the introduction, or not written well.26.0 ptsThis criterion is linked to a Learning OutcomeIssue IdentificationRequires critical thinking and creative thinking.12.0 ptsGoodClearly discussed the problem that the analysis is investigating. Clearly identified a primary issue.10.0 ptsFairDiscussed the primary issue that is being investigated somewhat, but not clearly identify the problem.5.0 ptsInadequateDiscussed a symptom of the problem only.12.0 ptsThis criterion is linked to a Learning OutcomeIssue AnalysisHow are you going to investigate your problem with this data?12.0 ptsGoodClearly discussed analysis plan (specifically mentions ANOVA, Linear Regression, or other analysis method). Clearly states research question in plain language. Correctly states statistical question that matches research question (null and alternative hypotheses).7.0 ptsFairMissing one of the elements of this section.3.0 ptsInadequateMissing two or more of the elements of this section.12.0 ptsThis criterion is linked to a Learning OutcomeDataWhere did the data come from? What did you do to prepare it for analysis?9.0 ptsGoodClearly discussed data: 1) Source 2) Any data cleansing required (treatment of outliers?) 3) Appropriate descriptive statistics table included.6.0 ptsFairMissing one of the required elements of this section.3.0 ptsInadequateMissing two or more elements of this section.9.0 ptsThis criterion is linked to a Learning OutcomeAnalysis9.0 ptsFull MarksClear discussion of analysis: 1) Identify variables (independent, dependent, type) 2) Relevant charts and tables 3) Discussion references any charts, tables, values (pvalue, etc.) needed to reach conclusion.6.0 ptsFairMissing one of the elements of this section.3.0 ptsInadequateMissing two or more elements of this section.9.0 ptsThis criterion is linked to a Learning OutcomeConclusion9.0 ptsFull MarksClearly discussed analysis conclusion: 1) Analysis results (significant, not significant) 2) Hypothesis conclusion (accept, reject) 3) Impact of your conclusion as it relates to the problem you identified in the "Issue Identification" section.6.0 ptsFairMissing one of the elements of this section.3.0 ptsInadequateMissing two or more elements of this section.9.0 ptsThis criterion is linked to a Learning OutcomeCOA'sCourse of Action Development8.0 ptsFull MarksStudent developed three or more courses of action (COA's) to the problem based on a better understanding of the problem obtained by their analysis. COA could optimize ROI, optimize time, optimize, optimize impact on people, "status quo", etc.6.0 ptsFairStudent developed two or more possible solutions.2.0 ptsInadequateStudent did not develop any possible solutions to the problem, or it was not clear that they understood how to think critically about solutions to the problem.8.0 pts
BUS 2001 Capella University Analyzing Data With Descriptive Statistics Question
Assessment 3 Instructions: Analyzing Data With Descriptive StatisticsPRINTUse a data generator to produce data for the que ...
BUS 2001 Capella University Analyzing Data With Descriptive Statistics Question
Assessment 3 Instructions: Analyzing Data With Descriptive StatisticsPRINTUse a data generator to produce data for the questions you developed in the previous assessment.IntroductionNote: Complete Assessment 2 before completing this assessment .In this assessment, you will use a data generator to produce data for your previously developed questions. You will then summarize the data by calculating various descriptive statistics and present the results graphically.Demonstration of ProficiencyBy successfully completing this assessment, you will demonstrate your proficiency in the following course competencies through the following assessment scoring guide criteria.Competency 1: Interpret a data set's central tendency and variability using descriptive statistical procedures.Calculate proportions correctly.Calculate means correctly.Calculate medians correctly.Calculate modes correctly.Calculate standard deviations correctly.Calculate ranges correctly.Competency 4: Solve problems in your personal and professional life by applying statistical procedures.Explain interesting findings or comparisons as a table, graph, or chart.Note: Complete Assessment 2 before completing this assessment.The following resources are required to complete Assessment 3. For this assessment, it very important that you have a good grasp on using Excel for numerical calculations and graphing. Review the resources as needed before attempting Assessment 3.Data Generator LinkUse the Survey Data Generator, which will provide you with simulated data for the questions you specified in Assessment 2. Enter the minimum value, maximum value, and expected value/typical response value you specified for the quantitative questions (Q5 and Q6) in Assessment 2. Then, click "Download Excel Spreadsheet." The Excel file will be saved in the download folder of your computer.Note: You might receive an alert about the file extension of the downloaded Survey Data Generator file. Click "Yes" to open the file.SoftwareCapella University requires learners to meet certain minimum computer requirements. As a Capella learner, to purchase some required or recommended software at a substantially reduced price, visit the Capella Software Store. Some software required for a course may exceed these requirements, in which case it will be provided to you via a virtual desktop or as part of your course materials. The following software is required to complete learning activities in this assessment.Microsoft Excel: Version 2010 or newer.Windows PC users: The Analysis Toolpak in Excel is a free add-in program—it provides data analysis tools that allow you to complete more complex statistical functions. If you do not yet have the add-in available in Excel, see instructions in Microsoft's Loading the Analysis Toolpak in Excel.Mac users: MS Excel 2016 has an available Toolpak add-in. For all other Mac users: StatPlus: mac LE is the free equivalent for Apple users, but must be downloaded from AnalystSoft.Microsoft Office/Excel ResourcesMicrosoft Corporation. (n.d.). Office support. Retrieved from http://office.microsoft.com/en-us/supportLoading the Analysis Toolpak in Excel. Retrieved from https://support.office.com/en-us/article/Load-the-...AnalystSoft. (n.d.). StatPlus: mac LE. Retrieved from https://www.analystsoft.com/en/products/statplusma...After having defined your survey questions in Assessment 2, you are now able to produce data. This will be done by using a data generator tool that generates hypothetical data for the questions you developed in Assessment 2. The data generator gives you information similar to what you might get when conducting the survey with actual persons.Once you have obtained the data by using the generator tool, use Excel to conduct your analysis and interpret the data using descriptive statistics and visual representations of the data.Data Generation and PreparationStep 1: Generate Data Using the Survey Data Generator.Open the Survey Data Generator. The Survey Data Generator will generate responses to the set of six survey questions you previously defined. It knows nothing about the particular subject of your study; it only generates a set of responses to question types that are pre-defined.Type the minimum, the maximum, and the expected values for questions 5 and 6 into the Survey Data Generator. (These are values for the quantitative questions from Table 1 of your completed Data Collection Template.) Note that the generator has spaces only for the values for your two quantitative questions.For the top set of boxes, enter the values for question 5.For the bottom set of boxes, enter the values for question 6.You must enter a single number for the minimum, the maximum, and the expected value for each of these questions.Do not enter any commas, decimal points, or other symbols.You will not enter anything into the generator for your binary questions (1–4). The tool knows that the only possible responses for these questions are 0 and 1. It will automatically generate 0s and 1s for the responses to your binary questions. Assign 0 and 1 to the two possible responses; it is up to you which response to assign 0 and which to assign 1. For example, if you asked "Are you male of female?" you could make Male = 0 and Female = 1, or vice versa.The Survey Data Generator will create an Excel file that represents responses to your questions. Once you have your unique survey data in Excel, you can apply descriptive statistics to the data and present your results in different visual representations to help an audience easily scan and understand your results.Explanation of data in Excel:There will be six columns (A–F) in Excel: one column for each question (1–6).Columns A–D represent the responses for questions 1–4 and should only contain 0s and 1s. Columns E and F represent the responses for questions 5–6 and should contain numbers between your minimum and maximum.Each row will represent the responses from one survey participant. For example, the first row of answers represents the first survey participant's answers to all six questions. The second row of answers represents the second survey participant's answers to the questions, and so forth. The number of rows of answers is how many participants completed the survey.If a column contains all the same numbers, you need to use the Survey Data Generator again. There has to be variation in these responses for you to statistically analyze the data. Check to see that columns 1 through 4 contain a mix of 0s and 1s and that columns 5 and 6 contain a range of different numbers between your minimum and maximum.Step 2: Prepare for Data Analysis in Excel.To be able to create a histogram in Excel, you need to be able to access the Data Analysis command. It should be visible on the Data tab, in the Analysis group to the far right in Excel. If it is not visible, you will need to install the Analysis ToolPak add-in.For instructions on loading the Analysis ToolPak add-in as well as for creating histograms, which is one of your tasks in this assessment, follow the steps on the Microsoft Microsoft Office Support site. Mac users: StatPlus: mac LE is the free equivalent for Apple users, but must be downloaded from AnalystSoft. Note: MS Excel 2016 now has an available Toolpak add-in. For more information, see the Software section under Required Resources.Enter the word "histogram" into the search box, and you will find information on how to install the ToolPak for your version of Excel as well as information on histograms.If you are not familiar with using Excel and its functions, a variety of helpful resources are provided in the Resources. In addition, you can choose any of the Excel tutorials from the Supplemental Resources in the left navigation menu of your courseroom.Technology note: You will need to sort or rearrange your data to accomplish some of these tasks. Be sure you keep a copy of your original Excel file as a backup.Results note: Because the survey data generation is done without context, you will have to put aside any preconceived notions about how your data should look. Your task is to analyze, interpret, and communicate the unique results.Data Analysis and InterpretationComplete your analysis (Parts 1–3) on one Excel sheet. Include the following components in your analysis of the data. You may wish to refer to the Analyzing Data With Descriptive Statistics Example [PDF] for further explanation. Note that in order to cover all the survey questions, your submission should include more tables, graphs, and charts than you see in the example.Part 1: Questions 1, 2, 3, and 4 (Binary Questions)Each question 1–4 should have the following elements:Sample size.Sample proportion of each response.Bar chart or pie chart.Part 2: Questions 5 and 6 (Quantitative Questions)Questions 5 and 6 should have the following elements:Sample mean.Sample median.Sample mode.Sample range.Sample standard deviation.Sample minimum and maximum.Histogram.Part 3: Exploration of DataNext, explore your data a bit further. What are two interesting findings from your survey responses? You might investigate responses for selected variables based on responses to your binomial questions. For example, if the answer to question 1 was Male or Female and to question 6 was Annual Income, you might examine average annual income for males only and females only and compare these results. Present your findings in an appropriate table, graph, or chart. Then write, in the same Excel spreadsheet, a 1–2 paragraph summary of your findings.Assessment Submission InstructionsSubmit your Excel spreadsheet containing Parts 1–3. Before submitting your assessment, verify you have included all of the elements listed above for Parts 1–3. It is important to note that you should have:Four bar graphs (or four pie charts), one each for questions 1–4.Two histograms, one each for questions 5 and 6.Two tables, graphs, or charts to represent interesting findings from your survey responses. Include a 1–2 paragraph summary of your findings.
MATH 410 Colorado State University Finer Suits Quantitative Business Analysis
Finer Suit Company sells suits in the US and the European Union. The company monitors its suit sales by collecting randoml ...
MATH 410 Colorado State University Finer Suits Quantitative Business Analysis
Finer Suit Company sells suits in the US and the European Union. The company monitors its suit sales by collecting randomly chosen data from store locations throughout the US and the EU. They record list price (in dollars), sale price (in dollars), and number of days it takes to sell each suit. Data were collected from 200 suits sold in the US and 200 in the EU region. The complete data set is in the file named Suits.
Managerial Report
Prepare a report (see below) that summarizes your assessment of the nature of the suit market in each region. Be sure to include the following seven items in your report.
Calculate descriptive statistics (mean, median, range, standard deviation, and coefficient of variation) to summarize each of the three variables for the all US suits. Use z-scores to determine if there any outliers in the data set for any of the three variables.
If there are any outliers in any category, please list them and state for which category they are an outlier.
If a result is an outlier, state whether it is below or above the mean.
How can one use the above descriptive statistics to understand the US suit market better? Could there be any other descriptive statistics that can help one understand the US suit market better?
Descriptive statistics (mean, median, range, standard deviation and coefficient of variation) to summarize each of the three variables for the all EU suits. Use z-scores to determine if there any outliers in the data set for any of the three variables.
If there are any outliers in any category, please list them and state for which category they are an outlier.
If a result is an outlier, state whether it is below or above the mean.
How can one use the above descriptive statistics to understand the EU suit market better? Could there be any other descriptive statistics that can help one understand the EU suit market better?
Compare your summary results from #1 and #2. Discuss any specific statistical results that would help Finer Suits understand its two types of businesses.
Discuss any specific statistical results that would help Finer Suits understand its two types of
Develop a 99% confidence interval estimate of the population mean sales price and population mean number of days to sell for US suits.
What is the margin of error?
Interpret your results.
Interpret what each confidence intervals means.
How can both confidence intervals provide useful US suit sales information?
What other confidence interval would you choose to compute to obtain more information related to US suit sales? Explain why.
What happens to the confidence interval as the level of confidence is increased.
Develop a 99% confidence interval estimate of the population mean sales price and population mean number of days to sell for EU suits.
What is the margin of error?
Interpret your results.
Interpret what each confidence intervals means.
How can both confidence intervals provide useful EU suit sales information?
What other confidence interval would you choose to compute to obtain more information related to EU suit sales? Explain why.
Assume the Finer Suit Company requested estimates of the mean List Price for the US suits with a margin of error of $600 and the mean List Price of EU suits with a margin of error of $600. Using 99% confidence, how large should the sample sizes be for each one?
How could the sample size formula be useful in understanding both types of suit businesses? What are some advantages of a larger sample size?
Suppose a US suit has a list price of $1,500 and an EU suit has a list price of $1,200. What is your estimate of the final selling price (based on the percent difference for the sale and list price) and number of days required to sell each of these suits?
How would these two estimates be useful in this application?
Write a report that adheres to the formatting and APA expectations outlined on the CSU Global Writing Center (Links to an external site.). As with all written assignments at CSU Global, you should have in-text citations and a reference page.
Submit your Excel file in addition to your report.
Requirements:
Paper must be written in third person.
Your paper should be four to five pages in length (counting the title page and references page) and cite and integrate at least one credible outside source. The CSU Global Library (Links to an external site.) is a great place to find resources.
Include a title page, introduction, body, conclusion, and a reference page.
The introduction should describe or summarize the topic or problem. It might discuss the importance of the topic or how it affects you or society as a whole, or it might discuss or describe the unique terminology associated with the topic.
The body of your paper should answer the questions posed in the problem. Explain how you approached and answered the question or solved the problem, and, for each question, show all steps involved. Be sure this is in paragraph format, not numbered answers like a homework assignment.
The conclusion should summarize your thoughts about what you have determined from the data and your analysis, often with a broader personal or societal perspective in mind. Nothing new should be introduced in the conclusion that was not previously discussed in the body paragraphs.
Include any tables of data or calculations, calculated values, and/or graphs associated with this problem in the body of your assignment.
6 pages
Hypothesis Testing
Hypothesis testing is the bedrock of quantitative research. A statistical test was used to quantitatively determine the ef ...
Hypothesis Testing
Hypothesis testing is the bedrock of quantitative research. A statistical test was used to quantitatively determine the effectiveness of a larger ...
14 pages
Underrisk
Auto insurance in most countries is not an option. In the country, it is necessary that any vehicle has valid insurance fo ...
Underrisk
Auto insurance in most countries is not an option. In the country, it is necessary that any vehicle has valid insurance for it to operate in our ...
Similar Content
graph linear functions
Graph linear functions i just need a detailed explanation ...
York University Statistics Discussion
Discussion prompt
The data for this prompt is based on a sample of 500 weekly measures of multiple broadway musicals (a di...
Statistics questions number 4
...
Create line charts for the closing prices, statistics homework help
Chapter 3 DQ - problem 1 - revisedChapter 3, problem 1. Create line charts for the closing prices in the Excel file S &...
State the domain and range. (Enter your answers using interval notation.) domain
f(x) = 3−xState the domain and range. (Enter your answers using interval notation.)domain ra...
Using a given zero to write a polynomial as a product of linear factors
For the polynomial below, 3 is a zero.f(x) = x^3 - x^2 - 12x -18Express f(x) as a product of linear factors...
Related Tags
Book Guides
We Were Eight Years in Power
by Ta-Nehisi Coates
The Catcher in the Rye
by J. D. Salinger
The Adventures of Huckleberry Finn
by Mark Twain
Uncle Tom's Cabin
by Harriet Beecher Stowe
The Mayor of Casterbridge
by Thomas Hardy
Into Thin Air
by Jon Krakauer
Catch-22
by Joseph Heller
All Quiet on the Western Front
by Erich Maria Remarque
The Secret Life of Bees
by Sue Monk Kidd
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
IRP project
1 Draft IRPSummary:In the Independent Research Project (IRP), students conduct an analysis project using SAS primarily and ...
IRP project
1 Draft IRPSummary:In the Independent Research Project (IRP), students conduct an analysis project using SAS primarily and Excel as needed to analyze real-world data.In the first assignment (IRP Research Question and Data Set), you identified the data set you wanted to use, developed a research question, and identified a statistical question that could be answered analytically.In this assignment, you will create and submit a business memo (template attached) that clearly communicates your analysis of the data set you identified in the previous assignment. When you submit this draft of your IRP, you will get feedback from your classmates and your instructor. You should use this feedback to improve your IRP.In later assignments (IRP Memorandum, IRP Presentation, Presentation Questions Reply), you will submit the final version of your IRP, create and submit a PowerPoint presentation that summarizes your IRP, present your analysis via a recorded video presentation, and answer questions about your presentation.AttachmentsIRP Template 2018.docxIRP Draft (2)CriteriaRatingsPtsThis criterion is linked to a Learning OutcomeUse of software tools10.0 ptsGood8.0 ptsFair0.0 ptsInadequate10.0 ptsThis criterion is linked to a Learning OutcomeData Display15.0 ptsGood12.0 ptsFair0.0 ptsInadequate15.0 ptsThis criterion is linked to a Learning OutcomeAnalysis Procedure25.0 ptsGood20.0 ptsFair0.0 ptsInadequate25.0 ptsThis criterion is linked to a Learning OutcomeData Analysis Conclusion20.0 ptsGood16.0 ptsFair0.0 ptsInadequate20.0 ptsThis criterion is linked to a Learning OutcomeRecommended Actions20.0 ptsGood16.0 ptsFair0.0 ptsInadequate20.0 ptsThis criterion is linked to a Learning OutcomeDecision Approach10.0 ptsGood8.0 ptsFair0.0 ptsInadequate10.0 ptsTotal Points: 100.02 IRP PresentationUpload your IRP PowerPoint presentation to this assignment.You only have four minutes, so be concise and careful with your language.Use the PowerPoint Narration tool for your slides, even if you present face to face, it is good practice.Attachments: IRP Presentation TemplateIS 3310 Presentation Rubric Fall 2018 v2CriteriaRatingsPtsThis criterion is linked to a Learning OutcomeContentInformation on slides reflects understanding and effective summarization. Information has not simply been copied and pasted from another IRP memo. Information is presented in logical sequence/structure.60.0to >35.0 ptsGoodAll essential elements needed to explain the analyiss and decision are present.35.0to >10.0 ptsAdequateMissing an essential element that explains the analysis and recommendation.10.0to >0 ptsInadequateTwo or more essential elements needed to understand the analysis are missing.60.0ptsThis criterion is linked to a Learning OutcomeDesignEasy to read, good color choices, no eye charts. Appropriate use of charts, graphs, and images to effectively communicate to the audience.15.0to >13.0 ptsGoodGreat design, color choice. Appropriate charts, graphs, tables, etc. are used in the presentation to promote the narrative.13.0to >10.0ptsAdequateSome charts, graphs, tables, etc. are used in the presentation to promote the narrative.10.0to >0 ptsInadequatePoor use of images, tables, etc. to explain the analysis and recommendation.15.0ptsThis criterion is linked to a Learning OutcomeUse of language (Grammar and Word Choice)Presentation is free of spelling and grammatical errors10.0 ptsGoodNo noticeable errors apparent in the presentation.10.0to >0 ptsInadequateOne ore more grammar, spelling, or obvious factual errors that a good proofreading of the presentation should have caught.10.0ptsThis criterion is linked to a Learning OutcomePresentationPresenter spoke clearly and slowly enough to be heard by the audience. Presenter effectively communicated their recommendation based on their analysis.15.0 ptsVery good.Clear, well spoken, not rushed. Presenation was organized logically, and effectively communicated the presenter's recommendation.10.0 ptsAveragePresenation was understandable, but was rushed and not logically arranged.5.0 ptsCould be betterThe speaker was hard to understand, rushed through the presentation, are had annoying habits that made following the15.0pts3 IRP MemorandumIn this Independent Research Project (IRP), students provide a business decision recommendation using SAS primarily and Excel as needed to obtain real world data. The student will create and submit a business report that clearly communicates a recommendation based on their analysis of the data set that includes an analysis of different courses of action using weighted factors. The students will also create a Power Point presentation that summarizes their IRP and present their analysis live, via video-teleconference or as a recorded video presentation. The student will also answer questions about their presentation.DELIVERABLE:ATTACH:IRP MEMORANDUM TEMPLATEIRP Memo Final (3)IRP Memo Final (3)CriteriaRatingsPtsThis criterion is linked to a Learning OutcomeSalutationIdentify the audience for this IRP3.0 ptsGoodDate, From, To lines correct.1.0 ptsFairOne or more items incorrect.0.0 ptsInadequateTwo or more items incorrect.3.0 ptsThis criterion is linked to a Learning OutcomeSubject LineShould relate to the topic, be interesting.3.0 ptsGoodSubject line is relevant and informative.1.0 ptsFairSubject line is not relevant to the IRP.0.0 ptsInadequateSubject line does is not informative.3.0 ptsThis criterion is linked to a Learning OutcomeIntroductionSummary of the whole IRP. You may not be able to write this portion until you have finished the rest of the paper.26.0 ptsGoodParagraph 1: Summary of IRP. Paragraph 2: Discussion of tools and data. Paragraph 3: Summary of findings, analysis conclusion, and recommendation.16.0 ptsFairMissing one of the introduction paragraphs, or not well written.5.0 ptsInadequateMissing two or more of the relevant parts of the introduction, or not written well.26.0 ptsThis criterion is linked to a Learning OutcomeIssue IdentificationRequires critical thinking and creative thinking.12.0 ptsGoodClearly discussed the problem that the analysis is investigating. Clearly identified a primary issue.10.0 ptsFairDiscussed the primary issue that is being investigated somewhat, but not clearly identify the problem.5.0 ptsInadequateDiscussed a symptom of the problem only.12.0 ptsThis criterion is linked to a Learning OutcomeIssue AnalysisHow are you going to investigate your problem with this data?12.0 ptsGoodClearly discussed analysis plan (specifically mentions ANOVA, Linear Regression, or other analysis method). Clearly states research question in plain language. Correctly states statistical question that matches research question (null and alternative hypotheses).7.0 ptsFairMissing one of the elements of this section.3.0 ptsInadequateMissing two or more of the elements of this section.12.0 ptsThis criterion is linked to a Learning OutcomeDataWhere did the data come from? What did you do to prepare it for analysis?9.0 ptsGoodClearly discussed data: 1) Source 2) Any data cleansing required (treatment of outliers?) 3) Appropriate descriptive statistics table included.6.0 ptsFairMissing one of the required elements of this section.3.0 ptsInadequateMissing two or more elements of this section.9.0 ptsThis criterion is linked to a Learning OutcomeAnalysis9.0 ptsFull MarksClear discussion of analysis: 1) Identify variables (independent, dependent, type) 2) Relevant charts and tables 3) Discussion references any charts, tables, values (pvalue, etc.) needed to reach conclusion.6.0 ptsFairMissing one of the elements of this section.3.0 ptsInadequateMissing two or more elements of this section.9.0 ptsThis criterion is linked to a Learning OutcomeConclusion9.0 ptsFull MarksClearly discussed analysis conclusion: 1) Analysis results (significant, not significant) 2) Hypothesis conclusion (accept, reject) 3) Impact of your conclusion as it relates to the problem you identified in the "Issue Identification" section.6.0 ptsFairMissing one of the elements of this section.3.0 ptsInadequateMissing two or more elements of this section.9.0 ptsThis criterion is linked to a Learning OutcomeCOA'sCourse of Action Development8.0 ptsFull MarksStudent developed three or more courses of action (COA's) to the problem based on a better understanding of the problem obtained by their analysis. COA could optimize ROI, optimize time, optimize, optimize impact on people, "status quo", etc.6.0 ptsFairStudent developed two or more possible solutions.2.0 ptsInadequateStudent did not develop any possible solutions to the problem, or it was not clear that they understood how to think critically about solutions to the problem.8.0 pts
BUS 2001 Capella University Analyzing Data With Descriptive Statistics Question
Assessment 3 Instructions: Analyzing Data With Descriptive StatisticsPRINTUse a data generator to produce data for the que ...
BUS 2001 Capella University Analyzing Data With Descriptive Statistics Question
Assessment 3 Instructions: Analyzing Data With Descriptive StatisticsPRINTUse a data generator to produce data for the questions you developed in the previous assessment.IntroductionNote: Complete Assessment 2 before completing this assessment .In this assessment, you will use a data generator to produce data for your previously developed questions. You will then summarize the data by calculating various descriptive statistics and present the results graphically.Demonstration of ProficiencyBy successfully completing this assessment, you will demonstrate your proficiency in the following course competencies through the following assessment scoring guide criteria.Competency 1: Interpret a data set's central tendency and variability using descriptive statistical procedures.Calculate proportions correctly.Calculate means correctly.Calculate medians correctly.Calculate modes correctly.Calculate standard deviations correctly.Calculate ranges correctly.Competency 4: Solve problems in your personal and professional life by applying statistical procedures.Explain interesting findings or comparisons as a table, graph, or chart.Note: Complete Assessment 2 before completing this assessment.The following resources are required to complete Assessment 3. For this assessment, it very important that you have a good grasp on using Excel for numerical calculations and graphing. Review the resources as needed before attempting Assessment 3.Data Generator LinkUse the Survey Data Generator, which will provide you with simulated data for the questions you specified in Assessment 2. Enter the minimum value, maximum value, and expected value/typical response value you specified for the quantitative questions (Q5 and Q6) in Assessment 2. Then, click "Download Excel Spreadsheet." The Excel file will be saved in the download folder of your computer.Note: You might receive an alert about the file extension of the downloaded Survey Data Generator file. Click "Yes" to open the file.SoftwareCapella University requires learners to meet certain minimum computer requirements. As a Capella learner, to purchase some required or recommended software at a substantially reduced price, visit the Capella Software Store. Some software required for a course may exceed these requirements, in which case it will be provided to you via a virtual desktop or as part of your course materials. The following software is required to complete learning activities in this assessment.Microsoft Excel: Version 2010 or newer.Windows PC users: The Analysis Toolpak in Excel is a free add-in program—it provides data analysis tools that allow you to complete more complex statistical functions. If you do not yet have the add-in available in Excel, see instructions in Microsoft's Loading the Analysis Toolpak in Excel.Mac users: MS Excel 2016 has an available Toolpak add-in. For all other Mac users: StatPlus: mac LE is the free equivalent for Apple users, but must be downloaded from AnalystSoft.Microsoft Office/Excel ResourcesMicrosoft Corporation. (n.d.). Office support. Retrieved from http://office.microsoft.com/en-us/supportLoading the Analysis Toolpak in Excel. Retrieved from https://support.office.com/en-us/article/Load-the-...AnalystSoft. (n.d.). StatPlus: mac LE. Retrieved from https://www.analystsoft.com/en/products/statplusma...After having defined your survey questions in Assessment 2, you are now able to produce data. This will be done by using a data generator tool that generates hypothetical data for the questions you developed in Assessment 2. The data generator gives you information similar to what you might get when conducting the survey with actual persons.Once you have obtained the data by using the generator tool, use Excel to conduct your analysis and interpret the data using descriptive statistics and visual representations of the data.Data Generation and PreparationStep 1: Generate Data Using the Survey Data Generator.Open the Survey Data Generator. The Survey Data Generator will generate responses to the set of six survey questions you previously defined. It knows nothing about the particular subject of your study; it only generates a set of responses to question types that are pre-defined.Type the minimum, the maximum, and the expected values for questions 5 and 6 into the Survey Data Generator. (These are values for the quantitative questions from Table 1 of your completed Data Collection Template.) Note that the generator has spaces only for the values for your two quantitative questions.For the top set of boxes, enter the values for question 5.For the bottom set of boxes, enter the values for question 6.You must enter a single number for the minimum, the maximum, and the expected value for each of these questions.Do not enter any commas, decimal points, or other symbols.You will not enter anything into the generator for your binary questions (1–4). The tool knows that the only possible responses for these questions are 0 and 1. It will automatically generate 0s and 1s for the responses to your binary questions. Assign 0 and 1 to the two possible responses; it is up to you which response to assign 0 and which to assign 1. For example, if you asked "Are you male of female?" you could make Male = 0 and Female = 1, or vice versa.The Survey Data Generator will create an Excel file that represents responses to your questions. Once you have your unique survey data in Excel, you can apply descriptive statistics to the data and present your results in different visual representations to help an audience easily scan and understand your results.Explanation of data in Excel:There will be six columns (A–F) in Excel: one column for each question (1–6).Columns A–D represent the responses for questions 1–4 and should only contain 0s and 1s. Columns E and F represent the responses for questions 5–6 and should contain numbers between your minimum and maximum.Each row will represent the responses from one survey participant. For example, the first row of answers represents the first survey participant's answers to all six questions. The second row of answers represents the second survey participant's answers to the questions, and so forth. The number of rows of answers is how many participants completed the survey.If a column contains all the same numbers, you need to use the Survey Data Generator again. There has to be variation in these responses for you to statistically analyze the data. Check to see that columns 1 through 4 contain a mix of 0s and 1s and that columns 5 and 6 contain a range of different numbers between your minimum and maximum.Step 2: Prepare for Data Analysis in Excel.To be able to create a histogram in Excel, you need to be able to access the Data Analysis command. It should be visible on the Data tab, in the Analysis group to the far right in Excel. If it is not visible, you will need to install the Analysis ToolPak add-in.For instructions on loading the Analysis ToolPak add-in as well as for creating histograms, which is one of your tasks in this assessment, follow the steps on the Microsoft Microsoft Office Support site. Mac users: StatPlus: mac LE is the free equivalent for Apple users, but must be downloaded from AnalystSoft. Note: MS Excel 2016 now has an available Toolpak add-in. For more information, see the Software section under Required Resources.Enter the word "histogram" into the search box, and you will find information on how to install the ToolPak for your version of Excel as well as information on histograms.If you are not familiar with using Excel and its functions, a variety of helpful resources are provided in the Resources. In addition, you can choose any of the Excel tutorials from the Supplemental Resources in the left navigation menu of your courseroom.Technology note: You will need to sort or rearrange your data to accomplish some of these tasks. Be sure you keep a copy of your original Excel file as a backup.Results note: Because the survey data generation is done without context, you will have to put aside any preconceived notions about how your data should look. Your task is to analyze, interpret, and communicate the unique results.Data Analysis and InterpretationComplete your analysis (Parts 1–3) on one Excel sheet. Include the following components in your analysis of the data. You may wish to refer to the Analyzing Data With Descriptive Statistics Example [PDF] for further explanation. Note that in order to cover all the survey questions, your submission should include more tables, graphs, and charts than you see in the example.Part 1: Questions 1, 2, 3, and 4 (Binary Questions)Each question 1–4 should have the following elements:Sample size.Sample proportion of each response.Bar chart or pie chart.Part 2: Questions 5 and 6 (Quantitative Questions)Questions 5 and 6 should have the following elements:Sample mean.Sample median.Sample mode.Sample range.Sample standard deviation.Sample minimum and maximum.Histogram.Part 3: Exploration of DataNext, explore your data a bit further. What are two interesting findings from your survey responses? You might investigate responses for selected variables based on responses to your binomial questions. For example, if the answer to question 1 was Male or Female and to question 6 was Annual Income, you might examine average annual income for males only and females only and compare these results. Present your findings in an appropriate table, graph, or chart. Then write, in the same Excel spreadsheet, a 1–2 paragraph summary of your findings.Assessment Submission InstructionsSubmit your Excel spreadsheet containing Parts 1–3. Before submitting your assessment, verify you have included all of the elements listed above for Parts 1–3. It is important to note that you should have:Four bar graphs (or four pie charts), one each for questions 1–4.Two histograms, one each for questions 5 and 6.Two tables, graphs, or charts to represent interesting findings from your survey responses. Include a 1–2 paragraph summary of your findings.
MATH 410 Colorado State University Finer Suits Quantitative Business Analysis
Finer Suit Company sells suits in the US and the European Union. The company monitors its suit sales by collecting randoml ...
MATH 410 Colorado State University Finer Suits Quantitative Business Analysis
Finer Suit Company sells suits in the US and the European Union. The company monitors its suit sales by collecting randomly chosen data from store locations throughout the US and the EU. They record list price (in dollars), sale price (in dollars), and number of days it takes to sell each suit. Data were collected from 200 suits sold in the US and 200 in the EU region. The complete data set is in the file named Suits.
Managerial Report
Prepare a report (see below) that summarizes your assessment of the nature of the suit market in each region. Be sure to include the following seven items in your report.
Calculate descriptive statistics (mean, median, range, standard deviation, and coefficient of variation) to summarize each of the three variables for the all US suits. Use z-scores to determine if there any outliers in the data set for any of the three variables.
If there are any outliers in any category, please list them and state for which category they are an outlier.
If a result is an outlier, state whether it is below or above the mean.
How can one use the above descriptive statistics to understand the US suit market better? Could there be any other descriptive statistics that can help one understand the US suit market better?
Descriptive statistics (mean, median, range, standard deviation and coefficient of variation) to summarize each of the three variables for the all EU suits. Use z-scores to determine if there any outliers in the data set for any of the three variables.
If there are any outliers in any category, please list them and state for which category they are an outlier.
If a result is an outlier, state whether it is below or above the mean.
How can one use the above descriptive statistics to understand the EU suit market better? Could there be any other descriptive statistics that can help one understand the EU suit market better?
Compare your summary results from #1 and #2. Discuss any specific statistical results that would help Finer Suits understand its two types of businesses.
Discuss any specific statistical results that would help Finer Suits understand its two types of
Develop a 99% confidence interval estimate of the population mean sales price and population mean number of days to sell for US suits.
What is the margin of error?
Interpret your results.
Interpret what each confidence intervals means.
How can both confidence intervals provide useful US suit sales information?
What other confidence interval would you choose to compute to obtain more information related to US suit sales? Explain why.
What happens to the confidence interval as the level of confidence is increased.
Develop a 99% confidence interval estimate of the population mean sales price and population mean number of days to sell for EU suits.
What is the margin of error?
Interpret your results.
Interpret what each confidence intervals means.
How can both confidence intervals provide useful EU suit sales information?
What other confidence interval would you choose to compute to obtain more information related to EU suit sales? Explain why.
Assume the Finer Suit Company requested estimates of the mean List Price for the US suits with a margin of error of $600 and the mean List Price of EU suits with a margin of error of $600. Using 99% confidence, how large should the sample sizes be for each one?
How could the sample size formula be useful in understanding both types of suit businesses? What are some advantages of a larger sample size?
Suppose a US suit has a list price of $1,500 and an EU suit has a list price of $1,200. What is your estimate of the final selling price (based on the percent difference for the sale and list price) and number of days required to sell each of these suits?
How would these two estimates be useful in this application?
Write a report that adheres to the formatting and APA expectations outlined on the CSU Global Writing Center (Links to an external site.). As with all written assignments at CSU Global, you should have in-text citations and a reference page.
Submit your Excel file in addition to your report.
Requirements:
Paper must be written in third person.
Your paper should be four to five pages in length (counting the title page and references page) and cite and integrate at least one credible outside source. The CSU Global Library (Links to an external site.) is a great place to find resources.
Include a title page, introduction, body, conclusion, and a reference page.
The introduction should describe or summarize the topic or problem. It might discuss the importance of the topic or how it affects you or society as a whole, or it might discuss or describe the unique terminology associated with the topic.
The body of your paper should answer the questions posed in the problem. Explain how you approached and answered the question or solved the problem, and, for each question, show all steps involved. Be sure this is in paragraph format, not numbered answers like a homework assignment.
The conclusion should summarize your thoughts about what you have determined from the data and your analysis, often with a broader personal or societal perspective in mind. Nothing new should be introduced in the conclusion that was not previously discussed in the body paragraphs.
Include any tables of data or calculations, calculated values, and/or graphs associated with this problem in the body of your assignment.
6 pages
Hypothesis Testing
Hypothesis testing is the bedrock of quantitative research. A statistical test was used to quantitatively determine the ef ...
Hypothesis Testing
Hypothesis testing is the bedrock of quantitative research. A statistical test was used to quantitatively determine the effectiveness of a larger ...
14 pages
Underrisk
Auto insurance in most countries is not an option. In the country, it is necessary that any vehicle has valid insurance fo ...
Underrisk
Auto insurance in most countries is not an option. In the country, it is necessary that any vehicle has valid insurance for it to operate in our ...
Earn money selling
your Study Documents