Need help to solve this problem in Excel

Copper Contributor
  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

 

1 Reply

@Sunilrane12 

 

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?