Get instant live Excel expert help with AVERAGE Function

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need the inventory qty's to "trickle down" when I change the Target MOS (Months of Stock) for SK which is our priority. Basically, if we give SK X MOS, how many MOS does that leave AMZ and Wholesale? Also noting that each location has a different 1 Month Average, thus the Months of Stock (MOS) are different for each location.
Solved by M. S. in 15 mins
Need to sort a dataset by location, plant date and planting method to get an average emergence percentage for each combination of these. There are two locations, three plant dates and two planting methods. I would also like to create standard deviation for each average.
Solved by X. D. in 26 mins
Why does the percentage on D7 of 23.35% not equal the average percentage of the percentages in Column D 3-5 as this equals 22.17%? Is there a calculation that will take me back to the 23.35%? Thanks
Solved by I. J. in 11 mins
formula to find the biggest loss and win the average lose and win total wins all for the specific stock based on all my data Thanks
Solved by K. C. in 15 mins
trying to figure out an average commission rate with a few differenct scenarios...Assume 1 strategy (Global) and then ratio per service per country - Ok 2 things 1) I don't think we can assume USA (cents per share) on a notional basis...Maybe we just get 2 separate calcs and average them in the end (cps vs bps)? 2) Ho can I incorporate them ratios of the serice into this equation to help with an average summary 10:28:26 What I am trying to achieve is an overall assumption (on the high-end) of what my average commission charge (roundtrip) should look like per strategy (thus incorporating all the info provided((region, service, comm rate)
Solved by I. H. in 23 mins
Confirm a Standard Deviation Calculation Confirm a Exponential Moving Average Calculation Formulate An If Then Formula If a value is positive, then enter purchase one stock if not already in it. If negative, then purchase another stock if not already in it.
Solved by X. W. in 29 mins
1. Examine just the data relating to those who currently own or lease an Apple smartphone. Construct a confidence interval to describe the average intention to use their smartphone for purchasing products in the next month among current Apple users. 2. Examine just the data relating to those who currently do not own or do not lease an Apple smartphone. Construct a confidence interval to describe the average intention to use their smartphone for purchasing products in the next month among such users.
Solved by Z. Y. in 28 mins
For this you will use two two-variable data tables. The data tables are comparing the different regions around Brisbane, the number of properties in the region, with the month of the campaign, ranging from one to ten months. Use the following information to calculate costs and student numbers: 1. Each flyer costs $0.194 to be delivered by Australia Post. 2. Staff are paid $425 to run a skill training session. 3. For every 10 (or less) students in the skill training session, there must be one training staff member. (1-10 students require 1 training staff, 11-20 students require 2 training staff, etc.) 4. Each student pays $100 to attend the training session. 5. Based on Brisbane City data, each property has on average 2.6 people living there. Each of these are considered potential students. 6. In each month of the skill training campaign, flyers will be sent to all households in the regions. 7. The cost of printing flyers in defined in the Constants Sheet. 8. The predicted effectiveness of the advertising campaign in a month for recruiting new students has been research and is calculated using the following formula.
Solved by A. W. in 26 mins
First, average time between dates, signup date and 1st trip date. Second, what percent of drivers have >1 trip? Third, what is the estimated LTV?
Solved by B. H. in 25 mins
I have a table and want to find the average percent change in column T minus column V when the value in column W is >0. This is the formula I have tried, but it just returns #VALUE. =SUMPRODUCT((Data!W:W>0)*((Data!T:T)-(Data!V:V))/SUMPRODUCT((Data!V:V)*(Data!W:W>0))/COUNTIF(Data!W:W,">0"))
Solved by C. L. in 15 mins