Get instant live Excel expert help to learn how to create a statistical function in Excel?

I would like to create a scatter chart using 2 data series where i'm able to place the average in the center of the chart.

Hello, how to get the average of numbers? I am trying to get Excel to calculate a commission on a "less than simple" pay structure. Essentially, I get paid a percentage of net sales. That percentage is determined based on 2 criteria. For example: If my "Products Per Deal" is 1.00 and my average income per deal is $1000.00, then I will be paid 13.00% commission. If my "Products Per Deal" is 1.3 and my average income per deal is $1200, then my commission will be calculated at 15.50%. I have a table set up, I just don't know how to get Excel to figure out what percentage it is.

I am trying to measure excel max, average and mim

Hi, so given check in and check out times of a room in a hospital, I have to find the average room occupancy per hour in a given month.

1. Please calculate “Roomed Census” (see below for definition) for every hour beginning on February 1, 2014 at 1:00 and ending February 28, 2014 at 23:00 (this is 671 values). Now average these values based on hour of day across the entire month. What is the busiest (highest census) and the least busy (lowest census) hour of day for the ER, and what is the average census at those two hours? a. Roomed Census - This is the number of patients who are in rooms at a given point of time - census is a snapshot in time. Patients in rooms can be thought of as those who have been placed in a room but have not left as of that point in time.

Need help on average value of a function over an interval. I am looking for a formula that corrects allocates units from Jul to Dec. So I have 6 months, average km per day is 50 and column G is the interval km per day. I want to get rid of the decimal. instead of having part as 0.5, 0.5, 0.5, 0.5 in 4 months I want to have 0, 1,0,1.

Ho do you calculate average in excel using time (amount in a time period)

I have 2 separate files, one with clock in and out times for employees, and another with customer response times per customer. I want a way to average all of the response times per employee during the time that they are clocked in. The response time information is time stamped.

how to find the average value of a function to calculate the time period to create and shorten table to just each hour

A coworker tried to update the account names in my pivot table. Somehow she added a 2 to the end of all these Microsoft accounts. It causes my 4 week average formula to stop working, since it references the account name. These are all the #NA's you see in the right column. How can I edit the name back to the original so the formulas work again? I just need to remove the 2's from the end of each name. Thanks