Answer the questions 1-4

Excel Assignment 4 - 4 Questions - 100 Points You are the VP at a car dealership. Your hoss comes to you ane afternoon and asks if you could 1ell him the average profit per vehicle the dealership makes. He wants the information by the end of the day. Sounds easy enough except that each salesman keeps track of their average profit per vehicle and only 20 salesmen of the 40 employed work at the dealership on a given day. You collect the information below from the salesmen currently on shift. You want to give your boss an answer you are 95% confident in. What do you tell him? Prompt: Average Profit per Vehicle Question 1 40 points Caleulate the lower and upper confidence limit based on this information. Enter in the name of the data points you need to solve this. Lower Bound Upper Bound Question 2 10 points Bascd on your findings above, what will you tell your boss the average profit is at the company? The next day your boss comes to you and says he reviewed the statement you made and asks if' vou are sure about your answer. It just so happens the other 20 salesmen were at work that day and you are able to gather the remaining data points. What do you tell your boss? 3615 Question 3 40 points Calculate the lower and upper confidence limit based on this information. Enter in the name of the data points you need to solve this. Lower Bound Upper Bound Question 4 10 points Based on your findings above, what will you tell your boss the average profit is at the company