Using excel formulas find the following information.

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 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.00 $1,850.00 $4,620.00 $3,448.00 $2,158.00 $2,689.00 $4,896.00 $6,411.00 $5,128.00 $4,169.00 $1,689.00 $4,855.00 $2,177.00 $3,891.00 $4,588.00 $3,485.00 $3,489.00 $2,488.00 $4,812.00 $2,588.00

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

I need to use excel formulas to complete the question, I need help understanding how to plug in the formulas on excel to complete the problem.