I made regression for two variables, one is independent (time of first pizza) and dependent (second is number of pizza that day). Trying to determine if there is connection between time of first pizza order with number of pizza that day. Time of day is converted in elapsed time since start of working hours. My data set is:

enter image description here

then I used regression to test relation between "elapsed time" and "num of counts". Chart show relation between this two variables.

enter image description here

After I done regression using excel I got this results

enter image description here

I am trying to model time of creations ( I did find distribution for number of pizza) . Trying to determine if number of pizza for some day influence on time of first pizza creation and I believe that this shows that there is weak connection between this two variables. F parameter should indicate that results are statistically significant.But I am not sure how to interpret this P value.


marked as duplicate by Scortchi Jan 8 at 15:59

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • 1
    $\begingroup$ Do you have sufficient data to determine if there is any seasonal variation? For example, the presence of ice and snow on the reads in some areas might have a strong effect, and it could be important whether or not your data is from such locations. $\endgroup$ – James Phillips Jan 8 at 13:42
  • 1
    $\begingroup$ This regression is based on an inappropriate model. A simple point of departure would be to posit that the number of pizzas has a Poisson distribution whose mean is directly related to the amount of time left after the first one has been made. This calls for a generalized linear model (and the use of software other than Excel). Neither is appropriate for assessing whether the number of pizzas "influences" the first time. That makes no sense unless the number of pizzas is somehow determined before the first pizza is made. How could that happen? $\endgroup$ – whuber Jan 8 at 18:22
  • $\begingroup$ I have data that show $\endgroup$ – explorer Jan 9 at 11:31
  • $\begingroup$ I have data set: day 1; first pizza 08:20; second pizza 08:50; and so on.. I wanted to determine if there is influence of number of pizza on those times of creations. not just for first one but in general. Possible that my approach is wrong, any ideas are welcome. $\endgroup$ – explorer Jan 9 at 11:47