Answer 1-4 questions and explain with excel

Back Excel Assignment 4.xisx Confidence Interval t-distribution Assignment Excel Assignment 4 - 4 Questions - 100 Points You are the VP at a car dealership. Your boss comes to you one afternoon and asks if you could tell him the average profit per vehicle the dealership makes. He wants the information by the end Prompt: 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? Average Profit per Vehicle 5,125 1,850 4,620 3,448 2,158 2,689 4,896 6,411 5,128 4,169 1,689 4,855 2,177 3,891 4,588 3.485 3.489 2,488 4,812 2,588 Question 1 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 2 10 points Based on your findings above, what will you tell your boss the average profit is at the company? Prompt: The next day your boss comes to you and says he reviewed the statement you made and asks if you 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? Average Profit per Vehicle 5,125 1.850 4,620 3,448 2,158 2,689 4.896 6,411 5,128 4,169 1,689 4,855 2,177 3,891 4,588 3,485 3,489 2,488 4,812 2,588 4,258 3,155 3,892 2,988 3,500 2,458 5,348 4,122 5,841 1,244 3,678 5,133 2,645 4,722 2,841 1,879 3,610 5,179 3,615 2, 130 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