couple of questions in microsoft excel
$10-30 USD
Paid on delivery
1) Find the equation that best fits this set of data. Print the spreadsheet and write the equation out by hand (include the estimated error on each coefficient).
x y
1.0 36.6
2.0 39.6
3.0 31.3
4.0 13.6
5.0 -11.3
6.0 -41.0
7.0 -74.2
8.0 -108.0
9.0 -140.7
10.0 -170.0
11.0 -194.0
12.0 -210.4
13.0 -217.3
14.0 -212.4
15.0 -193.8
16.0 -159.2
17.0 -106.6
18.0 -34.0
19.0 60.8
20.0 190.0
2) Provide a full page graph of the data (data points but no line) with the best fit line (solid line) drawn on the graph The full page graph should have a title, and both axes labled.
3) Report the average and standard deviation for both the x and y column (using excel, it will show on the printed spread sheet).
4) Take a point by point first and second derivative of the data and generate a graph of each of them. Print both and determine where minimums, maximums and inflection points occur.
Project ID: #12839835
About the project
7 freelancers are bidding on average $25 for this job
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More
I’m a writer, an idea guy, and a difference-maker. I write with passion, discernment, perception, credibility, and punctuality which make me come up with the best result ever. Also, I deliver great results with a p More
Hello I am Rajesh having a PhD and 15 years of experience in using Excel. I understand your work very well and will be completing it in couple of hours after award. Looking forward to work with you. Thanks.
Dear client? I have read and understood what the project needs. With my good experience in this area, i believe i Will deliver good work and in time if awarded. Kindly contact me for more details. Thank you
Hi, This is Neha. I am a Statistician and currently I am working in a company as a Data Analyst. I have also been working as a freelancer for Data Analysis and interpretation, Statistical Research work and writing rep More