I am trying to figure out how to fit a curve to my data using MS excel
The graph is a frequency distribution histogram with time on the x axis split into 5 minute bins and the number of jobs in each bin on the y axis.
I am pretty certain that the data is some kind of log normal distribution.
What I want to do is to find a fitted distribution using the lognormal formula and put in "adjustable" constants.I then want to deduct the sample frequencies from the fitted frequencies to get residuals. I will then take the sum of the squared residuals and place it on the screen at the bottom of the squared residuials column.. Finally, I want to square the residuals (to yield all positive numbers).
Then, I call up Solver. I enter my x values and my adjustable constants (mean, sd and cumulative) press "solve" and I should get a curve that is close to my estimate. Except that I don't.
I am having trouble generating a "fitted" data column since I am not sure how to write out to lognormal funtion in excel - I just can't seem to get it right after three days of trying
Recently Asked Questions
- I tried it again and get 17 mars bars, can anyone crosscheck my answer?
- Part 1: NIST publishes Special Publications (SP) to help government agencies and private companies develop and support security programs. The SP 800 subseries
- Which of the following are suitable null hypotheses? If not, explain why. a.Comparing two groups Consider comparing the average blood pressure of a group of