New Contributor

# Need help to solve this problem in Excel

1. You’re an analyst for Australia and are asked to make a Runs Prediction for Rohit Sharma for an upcoming ODI based on the below data - What parameters and modelling scenarios will help you arrive at a number? Can you make a basic predictor that will you arrive at a number?

Scenario – This ODI at Hyderabad with India facing Australia

 Rohit Sharma Metric Mat Inns NO Runs HS Ave BF SR 100s 50s 4s 6s ODI Career 233 226 33 9376 264 48.58 10513 89.18 29 45 856 250 vs Australia 40 40 4 2208 209 61.33 2352 93.87 8 8 178 76 in 2022 3 3 0 78 60 26 74 105.4 0 1 13 1 Matches held In India 71 70 8 3696 264 59.61 3721 99.32 11 16 370 116

# Re: Need help to solve this problem in Excel

OK.

This definitely IS a homework assignment for a class.  Most of us who answer questions here on this site have agreed we're not here to do homework for students, especially not when all those students do is copy verbatim the question they've been assigned to solve. This one, coupled with that one, basically established beyond a doubt that you're a student.

You are NOT going to learn how to use Excel by asking others to do the work for you.

So what have you tried so far? What functions have you used? What formulas have you created? Where have you run into a stumbling block?