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

What are the mean and median Next 12 Months PE Ratios of the group? Expert_777

Worksheet Q30-31 What are the mean and median Next 12 Months PE Ratios of the group?

hello i need help cnverting time into minutes and, i need to find the median and the quartiles for each categories.

Question on how to calculate excel maximum value and median from a large data set for different categories

I need to analyse 3 CSV worksheets with data from an outbound call centre to encourage people to sign up for a loan: leads.csv is a list of contact details that were fed into the call centre's systems for agents to call calls.csv is a list of calls made by the call centre to leads. There may be no calls or multiple calls to some leads. Each call is given an outcome i.e 'interested' (leads with an interested call does not necessarily mean they signed up and one lead may have multiple 'interested' calls) signups.csv is a list of leads who actually signed up (this may or may not have been after an 'interested' call). Each signup was risk assessed and either approved or rejected for a loan. I need to figure out: (i) How many signups each agent got (A Signup is assigned to the last agent who called the corresponding lead, in cases where multiple agents called the lead) (ii) Which agent had the most signups per call? How many? (iii) What was the mean and median number of calls to a lead before that lead was first marked as interested?

I need to analyse 3 CSV worksheets with data from an outbound call centre to encourage people to sign up for a loan: leads.csv is a list of contact details that were fed into the call centre's systems for agents to call calls.csv is a list of calls made by the call centre to leads. There may be no calls or multiple calls to some leads. Each call is given an outcome i.e 'interested' (leads with an interested call does not necessarily mean they signed up and one lead may have multiple 'interested' calls) signups.csv is a list of leads who actually signed up (this may or may not have been after an 'interested' call). Each signup was risk assessed and either approved or rejected for a loan. I need to figure out: What was the mean and median number of calls to a lead before that lead was first marked as interested?

What is the formula to find the Median of a list of items (all in one column), only including values that meet certain criteria in other columns (but in the same row)?

I need a vlookup return multiple values and in the same function I would like to find the median of these values that are returned.

Need to calculate out two equally spaced points between a range of dates. Basically like the MEDIAN function between two cells that have dates, but I need to produce two equally spaced points between that range. For example. If I have the following date range (A1) 2/2/2018 (B1) 7/2/2018, then that's roughly 150 days total. I want 4 equally spaced points (Start, Start-Mid, Mid-End, End). So I'd say that's 50 day chunks spaced euqally. Which would produce 4 total dates 2/2/2018 - 3/24/2018 - 5/13/2018 - 7/2/2018.

i have this formula currently which works but not if I want it for every day - any ideas ?? (NETWORKDAYS.INTL(L1362,M1362,11,BH!A:A)-1)*("17:30"-"8:30")+IF(NETWORKDAYS.INTL(M1362,M1362,11,BH!A:A),MEDIAN(MOD(M1362,1),"8:30","17:30"),"17:30")-MEDIAN(NETWORKDAYS.INTL(L1362,L1362,11,BH!A:A)*MOD(L1362,1),"8:30","17:30")