modify my statistics formula to forecast a student's next exam result via microsoft excel- £30

Completed Posted 4 years ago Paid on delivery
Completed Paid on delivery

Work needed asap. Unfortunately I need this to move quickly.

I have developed an excel file that looks to forecast a students next exam result based on 3 things. 1- linear regression formula. 2- an input scored 1-100 answering a question on subject simplicity. 3- an input scored 1-100 answering a question on time/ focus to subject for next exam only.

It works well for when the student has logged 6 exams plus. It is not accurate for when a student only logs 3-4 exam results in.

I need a formula that will look at the 3 factors stated, and will remain somewhat accurate even if the student has only sat 3-4 exams vs 9 exams.

The formula must flex depending on how many exams the student has logged for that subject. I need the formula in an excel format.

Budget is small as I have done a lot of the work already. Just need a touch up. Anything more than £30 is too much as this is a small job.

File attached for view. Please view the different tabs to see formula so far.

I have bigger jobs coming up that requires somebody to create more complex formulae with a bigger budget. I will be keen to rehire and create a job from scratch.

Regards,

Aaron

Statistics Excel Statistical Analysis Matlab and Mathematica Mathematics

Project ID: #20905322

About the project

6 proposals Remote project Active 4 years ago

Awarded to:

kb819253

Hello sir ! we a group , each one of us has an Engineer degree in Applied mathematical modelling , Economics and Statistics with 9 years of professional experience working as a Quantitative Analyst (in the field of St More

£29 GBP in 1 day
(14 Reviews)
3.4

6 freelancers are bidding on average £67 for this job

asadkhan3533

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan

£30 GBP in 1 day
(173 Reviews)
6.7
umairali8062

I have read your project in detail and I am expert in this field . I can do this for you within due time and honestly Kindly contact .Thanks

£30 GBP in 7 days
(17 Reviews)
4.1
obadiakipkemoi

I'm an exceptionally good statistician with vast experience and expertise both in qualitative and quantitative research and data analysis. I'm also an academic research writer. I'm liberal, thus can work in variety of More

£30 GBP in 1 day
(10 Reviews)
4.0
Rinkup0

⭐ Fair Price! High Quality! Speed Work!⭐ I am a Virtual Assistant ane ready to assist you for the job. I have over 7 years of administrative support experience to bring to the table. Effective communication, attention More

£250 GBP in 12 days
(4 Reviews)
2.1
JackKarl

Hi,dear. I have just read your project and I felt happy to see it. I have experienced for +7 years in this field. Particularly, I have ever done the job like this as you want. I want to hear your advice and discuss in More

£30 GBP in 1 day
(2 Reviews)
1.0