couple of questions in microsoft excel

Closed Posted 7 years ago Paid on delivery
Closed 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.

Excel

Project ID: #12839835

About the project

7 proposals Remote project Active 7 years ago

7 freelancers are bidding on average $25 for this job

schoudhary1553

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

$34 USD in 0 days
(93 Reviews)
6.0
ExpertzWorld

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

$25 USD in 1 day
(2 Reviews)
2.5
rajeshkumararora

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.

$15 USD in 1 day
(3 Reviews)
2.0
basho267

Hi , I am a Master of Finance student. Last semester I took a Financial Spreadsheeting class, which familiarized me with Advanced Excel and Vba. I would like to help you with this one and look forward to discussing More

$25 USD in 2 days
(2 Reviews)
1.6
ITIRITHIA92

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

$25 USD in 1 day
(0 Reviews)
0.0
ne26sharma

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

$30 USD in 0 days
(0 Reviews)
0.0