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

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