Question: I have this data here and its asking me to Linearize the data and plot it in EXCEL. If you don't know plotting in excel

I have this data here and its asking me to Linearize the data and plot it in EXCEL. If you don't know plotting in excel its fine, but how to Linearize data?

X:

2.51 3.27 3.65 4.29 4.19 3.99 3.69 3.68 3.39 3.15 3.03 2.95 2.76 2.84 2.84 2.68 3.04 3.31 3.54 3.42 3.42 3.9 7.64 6.89 5.86 4.77 4.41 4.59 4.17 4.07 3.53 3.26 3.93 3.55 3.86 3.69 4.09 4.01 3.74 3.64 3.46 3.39 3.45 3.42 3.56 3.53 3.33 3.32 3.24 3.29 3.34 3.22 3.27 3.24 3.55 4.04 4.86 5.18 4.52 4.36 5.58 8.2 7.39 6.07 4.96 4.23 4.07 4.12 4.22 4.12 4.02 3.79 3.87 3.63 3.56 3.12 2.48 2.79 3.12 3.19 3.25 3.3 3 3.06 3.05 3.07 3.15 5.04 12.22 12.29 11 9.1 7.91 6 5.44 5.27 12.02 11.05 9.43 7.5 5.93 5.86 6.05 6.28 9.64 13.61 12.28 11.58 10.54 13.21 15.28 14.36 17.6 18.37 16.7 14.82 13.41 12.96 11.81 11.12 10.01 9.32 8.66 8.2 7.25 6.93 6.61 6.35 6.26 5.85 6.57 11.39 10.64 9.06 7.98 8.15 10.63 9.52 7.89 6.8 6.07 5.67 5.42 5.01 4.94 4.74 4.63 4.52 4.61 4.37 4.35 4.53 4.99 7.8 7.33 6.6 5.76 5.3 5.33 5.19 6.15 6.51 5.38 4.85 4.49 4.28 4.23 3.89 3.95 3.81 3.89 4.22 7.19 9.88 9.68 8.07 6.18 7.06 9.35 9.28 8.24 8.83 14.28 13.31 11.86 10.27 8.82 9.75 16.28 16.84 14.6 11.77 10.19 9.03 8.62 8.46 7.62 7.07 6.55 6.04 5.48 5.37 5.71 5.36 5.06 4.8 4.53 4.31 4.25 4.22

Y:

2250 3170 3670 4560 4410 4130 3720 3710 3320 3020 2870 2770 2540 2640 2640 2450 2880 3220 3520 3360 3360 4010 10200 8800 7010 5270 4730 5000 4390 4250 3500 3150 4050 3530 3950 3720 4270 4160 3790 3650 3410 3320 3400 3360 3550 3510 3240 3230 3130 3190 3260 3100 3170 3130 3530 4200 5410 5900 4890 4660 6550 11300 9720 7360 5560 4470 4240 4310 4460 4310 4170 3850 3960 3640 3550 2980 2210 2570 2970 3060 3150 3210 2830 2910 2890 2920 3020 5680 20100 20200 17200 13100 10700 7250 6320 6050 19600 17300 13800 9930 7120 7010 7320 7720 14200 23500 20200 18600 16200 22500 28200 25600 36700 40400 32900 26800 23000 21900 19100 17500 15000 13600 12200 11300 9460 8870 8300 7840 7690 6990 8230 18100 16400 13000 10800 11200 16400 14000 10700 8640 7360 6690 6290 5640 5530 5220 5060 4890 5030 4670 4640 4910 5610 10500 9610 8280 6840 6090 6140 5920 7500 8120 6220 5390 4850 4540 4470 3990 4080 3880 3990 4460 9350 14700 14300 11000 7550 9110 13600 13500 11400 12500 25300 22700 19200 15600 12500 14500 31500 33400 26200 19000 15400 12900 12100 11800 10200 9130 8190 7310 6380 6210 6760 6190 5710 5310 4910 4590 4500 4460

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!