Statistics homework
**Problem-1: If your overall sale probability is 4 bicycles a day, what is your total bicycle sale number for 100 days. Calculation:
4 * 100 = 400 bicycles
***Problem-2: If your overall sale probability is 3 satellite dish a day, what is your total satellite dish sale number for 250 days? Calculations: 250 * 3 = 750 bicycles
***Problem-3: Use the attached excel file and calculate poison probability for true and for false. Based on poison probability: s is sample size, mean is mean that you expect (from your excel data), and cumulative is true or false. Calculate the Poison information for True and put the result for the following problem-3. Calculate the Poison information for False and put the result for the following problem-4.
***using attached excel file: a: open the attached excel file for assignment-5. b: click on fx in excel and a box opens with a drop-down on the box. c: click on the drop-down and a list comes on the screen. Choose statistical from the list and click on that. d: a list of statistical procedures comes on the screen. e: choose poison from the statistical choices and click on that. f: a new page opens asking for s (sample size) in the study. Put 10 for sample size, put .63 for mean, and put true for cumulative value. g: value of Poison for true will come on your screen. Remember that value to put it in the following line.
**Problem 3: The value of Poison for the data for True is: 1
**Repeat the above procedures a to g (under D: using excel) again exactly, s=10, means=.63, but put False in your cumulative part of Poison and run the data again.
**Problem 4: The value of Poison for the data for False is: 1.44556* 10^-9
(Save all these calculated information as assign-5 file on your disk and upload it to blackboard as assignment-5). Due to Blackboard by: Saturday, October 10, by midnight.