Forum Discussion
Need help to solve this problem in Excel
- 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 |
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?
