# I need to calculate the percent error. Everytime I try to right click in Excel the data will not work. Thank you!

Please help me plot this data in excel. I need to calculate the percent error…I need help as soon as possible. Everytime I try to right click in Excel the data will not work. Thank you!

1.    Open Excel
2. Start a new workbook in EXCEL.
3.           Enter the following experimental data:
4.                   For row A1 enter “x”.
5.                   In row A2 enter “0.110”.
6.                In row A3 enter “0.125”.
7.                 In row A4 enter “0.150”.
8.                In row A5 enter “0.210”.
9.                   In row B1 enter “y”.
10.                   In row B2 enter “1.08”.
11.                In row B3 enter “1.32”.
12.                 In row B4 enter “1.58”.
13.                In row B5 enter “2.04”.
14.            Finish entering data.
15. The next part is to graph the data and then complete a curve fit which we will skip. The curve fit will give the equation y = 9.23x + 0.13. Use this equation to calculate the predicted y or yfit.
16.            In row C1 enter “y fit”.
17.            In row C2 enter “= 9.23*A2 + 0.13”.
18.            Click to select row C2. Then left click twice on the lower right corner of C2. This will calculate for row C3 – C5.
19. Now calculate the square of the error
20.       In row D1 enter “Error squared”
21.            In row D2 enter “= (B2 – C2)^2”.
22.            Click to select row D2. Left click the lower right corner twice to repeat the calculation for rows D3 – D5.
23. Now calculate the root mean square error.
24.           In row D6 enter ” = sqrt( Average(D2:D5) )”.
25.           When this is done you should have a value of 0.0516 in row D6. This is the rms error.
26. To calculate the percent error of the fit, calculate the average of the |y|.
27.           In row E1 enter “Abs(y)”
28.           In row E2 enter ” = abs(B2)”.
29.           Click to select row E2. Left click twice on the lower right corner of E2 to calculate for row E3 – E5.
30.         In row E6 enter ” = Average(E2:E5)”.
31. You should have a value of 1.505 in row E6.
32. Now calculate the percent error
33.      In row F1 enter “Percent error —>”
34.          In row G1 enter ” = D6/E6*100″.
35. Now repeat with a new set of data and answer the question below.
36. Question: Enter the experimental data below into an EXCEL workbook.
37.        Height difference    Acceleration
38.                0.110           1.05
39.                   0.125           1.34
40.                 0.150           1.54
41.                   0.210           2.10
42. The equation of the best-fit line is y = 9.97x + 0.02. What is the percent error of the fit? Use 3 decimal places.

I need the answer for the percent error =_______

Tags:
0 replies