Get instant live expert help on I need help with locally weighted regression

“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 a formula as follows: IF B6 says "Can it be repurposed" AND G6 says "Yes", true="Do we have usage rights?", false value = "Can it be created locally?" However IF B6 says "Can it be created locally?" and B6 says "Yes", true="What is the timeframe", false = "No support available" I have tried the following, but it returns the error "Too many arguments" =IF(AND(B6="Can it be repurposed?",G6="Yes"), "Do we have usage rights", "Can it be created locally?", IF(AND(B6="Can it be created locally?",G6="Yes"), "What is the timeframe", "No support Available ")) Essentially I need two IF,AND statements in one formula
Solved by K. F. in 27 mins
I'm trying to determine the weighted average
Solved by Z. C. in 20 mins
I need help creating a formula. Consist of 3 data points. 2 are weighted 35% and 1 is weighted 30%. The 2 weighted at 35% the value can range from 0% to 100%. The 1 weighted 30% the value range is 0%-11% but the lower the number the better. Example 0%=100% of the 30%weighted, if that makes sense.
Solved by K. J. in 24 mins
I have a problem regarding to Weighted average
Solved by X. J. in 30 mins
I am looking for a way to weight baseball statistics - ex, batting average weighted by times at bat, earned run average weighted by innings pitched.
Solved by F. J. in 23 mins