QuestionFor Questions 4-14, use Monthly Sales Data screenshot (won’t let me upload the excel file)QUESTION 4Given their performance record, what is the probability of having a month which will have monthly sales exceeding $9,000?NOTE:?nter a numerical value only, and round your response to??igits after the decimal point. For example, you would enter the probability of .34561 (equivalent to 34.561%) as?3456?n the box below; and .34566 (or 34.566%) as?3457. If you do not follow these formatting and rounding rules, you may not receive credit for your answer.QUESTION 5Given their performance record, what is the probability of having a month with less than $7,000 in sales?NOTE:?nter a numerical value only, and round your response to??igits after the decimal point. For example, you would enter the probability of .34561 (equivalent to 34.561%) as?3456?n the box below; and .34566 (or 34.566%) as?3457.?f you do not follow these formatting and rounding rules, you may not receive credit for your answer.QUESTION 6If you view the company’s performance record as a representative sample of its overall sales performance, and considering what you know about normal distribution, what is the dollar value for the 95th percentile?NOTE:?nter a numerical value only, do?ot?nclude the $ sign; and round your response to??igits after the decimal point. If you do not follow these formatting and rounding rules, you may not receive credit for your answer.QUESTION 7If you view the company’s performance record as a representative sample of its overall sales performance, and considering what you know about normal distribution, what is the dollar value for the lowest 25th percentile?NOTE:?nter a numerical value only, do?ot?nclude the $ sign; and round your response to??igits after the decimal point. If you do not follow these formatting and rounding rules, you may not receive credit for your answer.QUESTION 8Given the company’s performance record and based on the empirical rule of normal distribution (also known as the 68%-95%-99.7% rule), what would be the?ower?ound of the range of sales values that contains 68% of the monthly sales?NOTE:?nter a numerical value only, do?ot?nclude the $ sign; and round your response to??igits after the decimal point. If you do not follow these formatting and rounding rules, you may not receive credit for your answer.QUESTION 9Given the company’s performance record and based on the empirical rule of normal distribution (also known as the 68%-95%-99.7% rule), what would be the?pper?ound of the range of sales values that contains 68% of the monthly sales?NOTE:?nter a numerical value only, do?ot?nclude the $ sign; and round your response to??igits after the decimal point. If you do not follow these formatting and rounding rules, you may not receive credit for your answer.QUESTION 10An insurance company wants to make sure that its best customers (those with lowest value of insurance claims) stay with the company. To achieve this goal, the company plans to offer a 10% discount on the annual health insurance premium for customers with the lowest 20% of annual health care expenses. If the average annual health care expenses for a family of four is $3,450 with a standard deviation of $955, what is the amount of the maximum health care expense that will qualify for the proposed discount?NOTE:?nter a numerical value only, do?ot?nclude the $ sign; and round your response to??igits after the decimal point. If you do not follow these formatting and rounding rules, you may not receive credit for your answer.QUESTION 11A manager of a telemarketing firm wants to reward her best sales personnel. Each salesperson gets a list of customers to call.?he data has been collected on the number of sales made per 100 calls. Now the manager wants to evaluate this data in order to decide what should be considered “exceptional” performance. Use?ales_Record.xlsx?o answer questions 11-12.Based on this data, what is the expected number of sales (per 100 calls)?NOTE: Enter a numerical value only, do not include the $ sign; and round your response to??igits after the decimal point. If you do not follow these formatting and rounding rules, you may not receive credit for your answer.QUESTION 12Based on the data for Question 11, what is the standard deviation of sales per 100 calls?NOTE: Enter a numerical value only, do not include the $ sign; and round your response to 2 digits after the decimal point. If you do not follow these formatting and rounding rules, you may not receive credit for your answer.QUESTION 13This scenario applies to Questions 13 and 14.?SEE SCREENSHOT FOR REFERENCE)An analyst thinks that the overall growth of the economy would impact the rate of return of the investment portfolio for the next year. Based on historical data, the analyst has developed the following possibilities:What is the?xpected rate of return?or the next year?Note: Enter a numerical value only, do?ot?nclude the % sign; and round your response to??igits after the decimal point. For example, you would enter 34.56% (or .3456) as?4.56?n the box below.QUESTION 14Based on the scenario in Question 13, what is the standard deviation of this distribution?Note: Enter a numerical value only, do?ot?nclude the % sign; and round your response to??igit after the decimal point. For example, you would enter 34.56% (or .3456) as?4.6?n the box below.QUESTION 15Begin with the analysis you performed in the Module 1 Assignment on the data provided in?emp_Data.xlsx.Now, add the numerical summary needed to answer the following questions:(1)??ow does the?verage temperature?f the two cities compare? Please make sure you cite the statistics for both cities in your response.(2)??ow does the?tandard deviation?f temperatures for the two cities compare? Which city has a smaller standard deviation? Please make sure that you cite the standard deviation statistics for both cities in your response.Finally, assess the graph you’ve originally created for Module 1 assignment. (If you did not submit Module 1 assignment, please review Assignment 1 directions, create the graph, and include it in your response).(3)??rom the graph which you had created in the previous assignment, could you tell which city has a smaller standard deviation? Why, or why not? Please provide the graph that you had created in the previous assignment along with your answer.Image transcription textEconomic Growth Scenario ProbabilityPortfolio Rate of Return High Growth(More than 4%) 0.30 8% … Show more… Show moreAccountingBusinessManagerial AccountingBADM 509
Get a plagiarism-free order today we guarantee confidentiality and a professional paper and we will meet the deadline.