Skill(s) Being Assessed: Problem Solving - Data Analysis (Quantitative Communication)Criteria for Success: In this assignment, you will:Identify the purpose of the article and what problem it is addressing/trying to solve.Explain what categories of descriptive statistics are used in the study and how they are used to communicate the information found in the study and/or any conclusions/solutions posed.Make connections between the information presented/the problem and its larger impact to the world/your major/current job/future career goal.Create an accurate visual for the data that helps communicate a story/solution to the audience.Communicate recommended solutions using appropriate language and visuals for the purpose and audience.What to Submit / Deliverables: The assignment includes an application to a professional conference in two parts:1. A Conference Application Template [DOCX] with questions to complete.2. A PowerPoint presentation.What is the value of doing this assignment? This assignment gives you the opportunity to apply the statistical concepts and methods you have learned throughout the course to a current real world problem. You will continue to practice your problem solving skill through analysis of data—examining how others use descriptive statistics, and creating your own mathematical visuals in order to analyze and draw conclusions based on this data.You will also practice taking initiative in putting together a conference application on the problem identified and sharing your findings with a specific audience. This will additionally help you practice communicating effectively—a skill you can use in your personal and professional lives every day.As you work to complete this assignment, you will continue to practice results-driven strategies. You will have the opportunity to engage in a statistical process while working towards a specific goal, use measurement to report results, and consider the quality and integrity of data and the ways it can be used to effectively communicate solutions.Your goal for this assignment is to: Apply the statistical concepts and methods you have learned to a current real-world problem by using your problem solving, initiative, and results driven skills to complete an application and presentation for a professional conference that incorporates the data analysis, conclusions, and recommendations you have reached.What you need to complete this assignment:Newspaper article that uses statistical data.Conference Application Template [DOCX]PowerPoint or other presentation tool (check with your instructor if you have questions).Scenario:You are submitting an application to a professional conference on data-driven decision making. The application has two parts:Providing information to the conference organizers.Creating a presentation for the conference audience.Steps:STEP 1: Visit one of the following newspapers’ websites: USA Today, New York Times, Wall Street Journal, or Washington Post. Select an article that uses statistical data related to a current event, your major, your current field, or your future career goal. The chosen article must have been published after the start of this term.Examples may include:Elections/exit pollsAward shows (Oscars/Emmys/Grammys)SportsEconomy/job marketGender equalityHuman rights issuesThe article should use one or more of the following categories of descriptive statistics:Measures of Frequency - Counting Rules, Percent, Frequency, Frequency DistributionsMeasures of Central Tendency - Mean, Median, ModeMeasures of Dispersion or Variation - Range, Variance, Standard DeviationMeasures of Position - Percentile, QuartilesNote: Once you navigate to a publication’s website, it may be easiest to do a search with a statistics-related word (ex: standard deviation).The publications listed are suggestions. If you find an article from another source OR if you are uncertain the article contains all of the information necessary to complete the assignment, please let your instructor know. Your instructor can help you determine whether it is a good fit for this assignment. If you need additional help locating an article, contact a Strayer librarian for more assistance. Remember to review the examples in the Week 6 Discussion.STEP 2: Using the data from your article, use the template included in this assignment to answer the following questions asked by the conference organizers. Remember to consider their expertise as mathematical professionals and use appropriate language to communicate your findings:Highlight the purpose of the article and the problem it is trying to solve. Think summary, in bullet-form.Explain how the article uses descriptive statistics to communicate information found in the study and/or any conclusions/solutions.Explain how the article applies to the real world, your major, your current job, or your future career goal.Recommend solutions using the mathematical and visual data provided.STEP 3: An additional part of the application process requires you to create a presentation based on the information provided in the template.Based on your topic, choose an audience (outside of the field of mathematics) that could benefit from the information you will present. For example, this could be your local city council member, staff or administrators of a school, or employees at a company.Analyze the data in the article to determine the best visual (graph or chart) to tell the story to your audience.In PowerPoint or other presentation tool, create one visualization of the data appropriate for the conference audience. NOTE: If the article already contains a visual, you must create a different type of graph or chart.Explain how the audience can benefit from the data.Recommend your identified solutions using language appropriate for the audience.STEP 4: In the notes section of your final slide, answer the following questions:Explain why you chose the audience in Part B.Describe how the language, purpose, and visuals used in the PowerPoint are appropriate for the audience.STEP 5: Format your presentation according to the Strayer Writing Standards. Please take a moment to review the SWS documentation for details.STEP 6: Submit your assignment in two parts:The conference application template.Your presentation.Note: See an example Conference Application Template Example [DOCX] and Education and Life Expectancy [PPTX] example to see the length and content expected for this assignment.undefinedgrading rubric found here.

 New York Survey DataInstructionsA consulting firm was hired to perform a survey on people living in New York City. The survey was completed monthly for six months by 445 randomly selected people in different boroughs. There were a number of items on the survey, but six basic biographical items will be studied for this exercise. The data for the people surveyed in one of these monthly surveys can be found in the Excel file SURVEY. The variables that were used for the basic biographical data are found on the last page of the exercise.In this exercise, some of the estimation techniques presented in the module will be applied to the New York survey results. You may assume that these respondents represent a simple random sample of all potential respondents within the community, and that the population is large enough that application of the finite population correction would not make an appreciable difference in the results.New York City governmental agency personnel like to have point estimates regarding variables describing the biographical information of the people living within the different boroughs. It is very helpful for them to have some idea regarding the likely accuracy of these estimates as well. Therein lies the benefit of the techniques presented in this module and applied here.Item A in the description of the data collection instrument lists variables 1 through 5, which represent the respondent’s general attitude toward each of the five boroughs. Each of these variables has numerically equal distances between the possible responses, and for purposes of analysis they may be considered to be of the interval scale of measurement.Determine the point estimate, and then construct the 95% confidence interval for μ1= the average attitude toward Manhattan.Repeat part (a) for μ2through μ5, the average attitudes toward Brooklyn, Queens, The Bronx and Staten Island, respectively.Given the breakdown of responses for variable 6 (highest level of education), determine the point estimate, then construct the 95% confidence interval for π6= the population proportion of doctoral degrees.Given the breakdown of responses for variable 7 (marital status of respondent), determine the point estimate, and then construct the 95% confidence interval for π7 = the population proportion in the “single or other” category.Assume the governmental agencies requested estimates of the mean attitudes towards each borough with a margin of error of 0.05 for each borough. If the governmental agency personnel want to have 95% confidence that the sample mean will fall within this margin of error, how large should the sample sizes be for each borough?Paper RequirementsMUST BE IN APA FORMAT!! Items that should be included, at a minimum, are a title page, an introduction, a body that answers the questions posed in the problem, and a conclusion paragraph that addresses your findings and what you have determined from the data and your analysis. As with all written assignments, you should have in-text citations and a reference page too. Please include any tables of calculations, calculated values and graphs associated with this problem in the body of your assignment response.NOTE: You MUST submit your Excel file with your report. This will aid in grading with partial credit if errors are found in the report.A. General Attitude toward Each Borough (Variables 1–5)1. Manhattan2. Brooklyn3. Queens4. The Bronx5. Staten IslandLike Very Much(5)(5)(5)(5)(5)Like(4)(4)(4)(4)(4)Neutral(3)(3)(3)(3)(3)Dislike(2)(2)(2)(2)(2)Dislike Very Much(1)(1)(1)(1)(1)B. Information about the Respondent (Variables 6–7)What is your highest level of education? (1) = Did not complete High school(2) = High school degree/GED(3) = Associate’s degree(4) = Bachelor’s degree(5) = Master’s degree(6) = Doctoral degreeMarital Status: (1) = Married (2) = Single or other

please use excel to answer these questions, PLEASE READ ALL DIRECTIONS as there are a few different requirements and SHOW ALL WORK FOR EACH QUESTION WITH EXCELPlease make sure you put your name in the space provided at the top right corner of this page.Please insure that your copy of the exam has 8 numbered pages and 12 questions (and two EXTRA-CREDIT questions).You may use your textbook, computer, and notes. You should do all the work on your own and not get any help from others (this includes tutors). Integrate, i.e., cut & paste, computer printouts (as part of the response to the questions) for any questions you use the computer analysis results.For the normal distribution problems #8 and #9, draw appropriate pictures and mark relevant points on the picture by using the Minitab “graph à probability distribution plot” function (you could also do this by drawing the picture on paper, scanning it, and incorporating into your answer).Please turn-in this exam as an electronic (soft) copy. You should type in your answers on this document and turn it in for grading. Please name the Word file as you have done for all submissions in this class. GRADE SUMMARYProblems: Partial44Problems: Complete24Short essays32Extra-Credit10 Total110GOOD LUCKFor your use with Word, I am providing some symbols we have used in class. You may cut-and-paste these symbols as and when you need them on this.= < > ≥ ≤ ≠ µ σ σσ2 S S2H0: H1: a PROBLEMS --PARTIALFor the following three business situations please identify whether the probability distribution to be used to model the situation is Binomial, Poisson, or some other distribution (you do not need to identify this if it is not Binomial or Poisson distribution, just state that it is an unknown distribution) and for each situation justify your choice of the probability distribution by listing the requirements of the distribution and how they are met. (You are not required to solve these problems) (2 + 2 points)Any profit-maximizing firm would like a larger share of the market. The advertising campaign in different communications media is the most effective method to reach the consumers. Chuck Atwood, Optico Corporation’s sales manager, recently concluded a six-month advertising campaign which featured a series of ads in major business periodicals. The firm’s advertising agency assured Optico management that 60% of the purchasing agents in the target industries would be aware of the campaign. At a recent sales convention, only 4 of the 10 purchasing agents whom Chuck Atwood questioned could remember seeing any of the ads. Should Optico undertake a more detailed (and expensive) study of the advertising agency’s claim? Why?Pat Lowe, general manager of Chicago Foundries, is facing a difficult situation. Her plant is currently operating at 60 percent of optimal capacity and is losing money. She has submitted bids on two government contracts, either of which would bring the plant up to capacity. However, if she were to receive both, she would have to subcontract one of them and would be no better off than she currently is. Lowe recently received an invitation to bid on another government contract of the same nature and magnitude as the two she currently has bids on. She is unsure whether she should bid. She would prefer to operate at 60 percent capacity than to receive all three bids. Past experience has convinced her that she has received contracts of this nature 20 percent of the time. Advise Ms. Lowe.Telephone sales operators make on the average 1 call every 10 minutes. Recently, operators have become upset with their working conditions and you wonder if they are slowing down to retaliate. You observe one operator who has made no calls in the past 50 minutes. Assume that the average of 1 call every 10 minutes has not changed. What is the probability that no calls would have been made in the past 50 minutes?For the next four problems, just do the following: (You are not required to solve these problems)A.Set up Null (H0) and alternate (H1) hypotheses (i.e., Step 1) in business terms (i.e., in plain English). (2 points)B.Set up Null (H0) and alternate (H1) hypotheses (i.e., Step 1) in statistical terms. (2 points)C.In the context of the problem, please specify what kind of conclusion will lead to type I error and discuss the implications of making this type of error (i.e., who will it impact and how). (2 + 2 points)The Better Business Bureau has received several complaints that a flour company is underfilling their five pound bags of flour. The Bureau randomly selects 750 bags of flour and determines the weight of each bag. The sample average weight of the bags is 4.80 pounds with a standard deviation of .15 pounds. Is there evidence at the .01 level of significance that the bags are underfilled? A. H0 : H1 :B. H0 : H1 :C.5.The director of the IRS has been flooded with complaints that people must wait for at least 45 minutes before seeing an IRS representative. To determine the validity of these complaints, the IRS randomly selects 400 people entering IRS offices across the country and records the times which they must wait before seeing an IRS representative. The average waiting time for the sample is 55 minutes with a standard deviation of 15 minutes. Are the complaints substantiated by the data? Use a significance level, α, of .10.A. H0 : H1 :B. H0 : H1 :C. A 1990 Survey showed that the average check at Perkins family restaurant is $4.70. The Perkins company wants to know if this figure is too high for 1997. The Perkins company takes a random sample of 54 checks from the restaurants across the country and determines that the sample average check is $4.62. The sample standard deviation of the checks is $0.86. Using a = .05, test to determine whether the Perkins, restaurant check average is significantly lower than $4.70.A. H0 : H1 :B. H0 : H1 :C. To protect U. S. steel producers against competition from low-priced foreign imports, theGovernment has adopted a trigger price mechanism. If steel imports enter this country at less than the minimum or trigger price (based on the cost of production in Japan, which has the world's most efficient steel factories), an investigation into the illegal dumping of cheap steel in the United States by foreign countries is launched. Last year, the average trigger price was set at $358.31 per ton. This year, a random sample of n = 40 was selected, and the trigger price on each of the days was recorded. The data are summarized as follows: Sample mean = $330.88 S = $106.1Does the sample evidence indicate a need for an investigation of illegal dumping?A. H0 : H1 :B. H0 : H1 :C. ­­­­­­­­­­­­­­­­­­­­­­­­­­­­PROBLEMS – COMPLETE8.A well-known brand of size D batteries has a lifetime that is normally distributed with a mean of 105 hours and a standard deviation of 20 hours. A. What proportion of the batteries has a lifetime of less than 85 hours? (4 points) B. If a person buys 1 battery of this type, what would be the probability that its lifetime would be between 75 and 90 hours? (4 points) 9A A personnel researcher has designed a questionnaire and she would like to estimate the average time to complete the questionnaire. Suppose she samples 100 employees and finds that the mean time to take the test is 27 minutes with a standard deviation of 4 minutes. Construct a 90% confidence interval for the mean time to complete the questionnaire. (6 points) Also, write a short memorandum about the findings to the human resources director of your company summarizing the methodology, findings, results and conclusions. (4 points) – Use Minitab for this analysis.9B. For the problem in part A, the human resources director wants to know whether these is sufficient sample evidence to conclude that the average time to complete the questionnaire is not 27 minutes. Set up the hypotheses (in statistical terms) and, based only on the confidence interval you have constructed in part A, what would you conclude regarding the hypotheses? (6 points) H0 : H1 :Conclusion:ESSAYS (Please double space your work)Management researchers are interested in understanding factors that are related to success of managers in for-profit businesses. You have been hired as a consultant to assist the researchers. As you start your work, develop a plan that addresses the following (page limit: 2 pages):a)What is your clear definition of the problem? i.e., what is it that you would like to show with evidence from data and analysis? (4 points)b)What data would you collect? Identify and specify the variables (so that they can be measured), list them including type and level, and specify why each variable is useful (or needed) for the study. List a few (made-up) values for each variable. Be very specific and to the point. (6 points)c)Present a plan, for collecting the data specified above, in the form of a series of specific instructions for someone else that would actually collect the data for you. (6 points)d)Provide a justification for your plan as it pertains to the quality of the variables that you selected (i.e., explain why you believe that the variables are the best ones to measure to address the issue raised in the study). You may contrast your variables with others (or other ways to measure the same variables) of lesser quality to make your point that yours are the best. (4 points)Write a short tutorial describing, in your own words, "hypothesis testing" to a manager who is not very knowledgeable in business statistics. Do not list the steps or describe the statistical analysis, but describe it as a technique to solve business problems. Use an example problem/situation to illustrate your points. (Page limit: ½ page) (8 points)undefinedSuppose an investment broker’s claim is stated in the hypotheses as: H0: My clients earn an average return of at most 10% per year on their investments. H1: My clients earn an average return of more than 10% per year on their investments.What is the type I error here? What are the implications of this error? Who is affected and why? Explain. (4 points)