in Excel

The assignment is to be performed for the 3 given datasets (Cartesian, Semi-log, log-log).

Cartesian Scale
x	y
10	852
15	725
20	700
25	601
35	448
38	500
50	296
55	194
65	97

Semi-log Scale
x	y
1	4
2	6
4	10
6.2	20
7.9	30
10	30
11	70
12.1	130
13.6	150

Log-log Scale
x	y
2.5	3300
11	11000
12.5	11800
13.8	14100
3.3	4000
3.9	4900
4.6	5500
5	6300
6	7000
7	7200
8.3	8800
16.5	15500

in excel

Perform each question on all the 3 sets of data points. Part A - Best Fit Method 1. Plot the set of data points on the graph paper. Use the right scale to plot the data points. (3*2 = 6%) 2. Fit the plotted data points using the Best Fit Method and properly obtain the equation of the resulting line in each case (3*8 = 24%) Part B - Least Squares Method 1. Write a computer program or use a spreadsheet to determine the coefficients a and b for the data points (show all calculations). Use the equations in lab manual page 12. (3*8 = 24%) 2. Determine the line equation from the results you obtained from question 1. This will be the equation by using Least Squares Method. (3*8 = 24%) Part C - Final analysis 1. Plot the data points along with the two lines obtained by Best Fit Method (Part A) and Least Squares Method (Part B) in a single graph. Include axes labels and legends as required (3*4 = 12%) 2. Analyze and compare the differences between the line equations obtained using the two methods. (10%) NOTES: All your report must be completed using a word processor (*.doc, * docx, or *.pdf) and all graphs must be computer generated (MATLAB, Excel or other computer program). Your source code or spreadsheet must be included in the report. Handwriting and graphs drawn by hand will not be considered. Final line equations must be of the form: y = *** . Always use the same notation for all variables (e.g. use always a and b as the slope and intercept) Perform each question on all the 3 sets of data points. Part A - Best Fit Method 1. Plot the set of data points on the graph paper. Use the right scale to plot the data points. (3*2 = 6%) 2. Fit the plotted data points using the Best Fit Method and properly obtain the equation of the resulting line in each case (3*8 = 24%) Part B - Least Squares Method 1. Write a computer program or use a spreadsheet to determine the coefficients a and b for the data points (show all calculations). Use the equations in lab manual page 12. (3*8 = 24%) 2. Determine the line equation from the results you obtained from question 1. This will be the equation by using Least Squares Method. (3*8 = 24%) Part C - Final analysis 1. Plot the data points along with the two lines obtained by Best Fit Method (Part A) and Least Squares Method (Part B) in a single graph. Include axes labels and legends as required (3*4 = 12%) 2. Analyze and compare the differences between the line equations obtained using the two methods. (10%) NOTES: All your report must be completed using a word processor (*.doc, * docx, or *.pdf) and all graphs must be computer generated (MATLAB, Excel or other computer program). Your source code or spreadsheet must be included in the report. Handwriting and graphs drawn by hand will not be considered. Final line equations must be of the form: y = *** . Always use the same notation for all variables (e.g. use always a and b as the slope and intercept)