Get instant live Excel expert help with AVERAGE Function

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: A lead from which region was most likely to express interest, assuming they received at least one call? What proportion of leads from this region expressed interest? Assume that a lead with at least one ‘interested’ call has expressed interest.

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: Signups from which region are most likely to be approved? What proportion get approved?

what does =IF(ISBLANK(B278),"",H278-I278+J278) formula mean?

In excel, I want to create a list based on a single column from another sheet, without the rows that are empty for that column. The attachment shows what I mean. Sheet 1 is my original data entry, sheet 2 is my derived list.

The amount of mayonnaise dispensed from a machine at The Fast Food Factory is normally distributed with a mean of 0.85 g and a standard deviation of 0.1 g. If the machine is used 800 times, approximately how many times will it be expected to dispense 1 or more grams of mayonnaise.

My session ended and the techician did not complete what he was suppose to do said system was slow everytime I asked him if he was still there I never got a reply, now im finding that I cannot alter amounts in individual entry sheet?? If I do they will not appear in Pivot Table? Also WHY does a pop up keep appearing saying “Cannot open Pivot table” I need for this pop up to be removed as when Im done with this spreadsheet I need to email it to my Client. Please open up my spreadsheet so you can see what I mean? Also in individual entry sheet, I need Grand totals to show up automatically at the bottom of each amount coloum also reinstate coloum M has it hidden and coloum N has data that I cannot remove. Every move I make the pop up comes up on screen I cannot have this Pls help Thanks!

I want to create timeline for products, i have made 50% data (I mean I have completed template) I want you to fill it using formulas. I think vlookup can do this, still I am not sure Thank you

I need to sortout my data in excel. I mean I have a data as a paragraph and I need it in table in perfect row.

Hypothesis testing that returns of a company are greater than returns to the market using Data Analysis: t-test: 2 small assuming unequal variances what mean difference should I define?

Use the RANDBETWEEN function in Microsoft Excel to select three simple random samples of 10, 50 and 500 days from the population. Using just your samples, calculate the mean, median, standard deviations and mode if applicable for each random sample. [10%]. Compare these outcome figures. How do the mean and SD change with sample size? [10%].