بسم الله الرحمن الرحيم

1. بسم الله الرحمن الرحيم

2. Education is not the filling of a pail but the lighting of a fire William battler

3. What is solver function in excel & how it work?

4. if We go to the data tab. We can’t see the solver function by default. So we try to add it

5. Click here Then here

6. Click to add and wait …

7. Click on this

8. Tick the solver function to add it in to the data tab.

9. You can see the solver in here. Click to do some….. .

10. We want to maximize it This is a target cell , which in this case is R ^2 By changing this cells.

12. At the end click to solve

13. ok

14. We have a maximum goodness of fit .

15. We want to see the intercept & slope of our data .(not the fitted model)

17. Choosing the target cell

19. We should select dependent variable for first box & independent variable for the second box.

22. And the same process for calculating the slope.

23. At this time we want to add the regression function

26. Tick this and ok.

27. we can see data analysis function in here. Click and choose regression

29. Choosing Y and X range.

30. And seeing result in the new sheet.

31. You can do so many calculation by excel which are useful for training and understanding statistical concepts. والعاقل يكفيه الاشاره