Recent content by VECTOR

  1. VECTOR

    Excel - Statistics

    SOLVED IT!!!!
  2. VECTOR

    Excel - Statistics

    And more files:
  3. VECTOR

    Excel - Statistics

    I have done it now and it just totally slaughtered me. Nothing happens at my histograms.... Im posting Pictures of the histograms as well of how I have used the Formulas in the case of N=10.
  4. VECTOR

    Excel - Statistics

    I have not yet done more than n=2 as I wanted to check with you that I do correctly from the start! But will do first thing in the morning tomorrow as It seems ok! :D! Regarding your questions: The reason for why they did want me to do this task (Note; my thoughts) is to let me to...
  5. VECTOR

    Excel - Statistics

    Wonderful! :) I posted an correction as well ^^
  6. VECTOR

    Excel - Statistics

    I have now done just as stated as above. In this case I did the "first task" that the teacher asks me to do with 2 random numbers. I have made sure that you can see the Formulas for each row- just see the Pictures. How does it look? :)
  7. VECTOR

    Excel - Statistics

    Thank you! :) So i do this: I Find the standardisera by: z = (x_bar - mu)/(sd/sqrt(n)) Where X_bar = mean of x Standarddev of mean = sd/sqrt(n). Where n=in his case 5 Sd= sqrtLambda X_bar is in this case the mean from the randomized Numbers (as you see in the pics) ??
  8. VECTOR

    Excel - Statistics

    Answer: Thank you! Thus, I asked my teacher as well when I handed it in, according to him there is no Y bar in this test?
  9. VECTOR

    Excel - Statistics

    Haha thank you! I feel bad for My teacher on the other hand as he Will receive the work tonight, he Will probably loose his mind. Regarding what you stated above; What is y_bar? When it comes to the mean: Then Sd = sqrt(lambda) and (n)= 100, or is n=5? (as for in this example where I used...
  10. VECTOR

    Excel - Statistics

    Also note that there are 3 Pictures- might miss them if one does not look carefully :)
  11. VECTOR

    Excel - Statistics

    Hi! I Think I managed to do it now, please see the Pictures I did above (The Pictures are from the task where one should do 5). THUS There is something here that is not right, look at my histogram, the closer they get to zero, they should not look like that then…? Also; please note that what...
  12. VECTOR

    Excel - Statistics

  13. VECTOR

    Excel - Statistics

    Answer on the "Show step 1" I have tried now; (When it comes to number 1). Please see the Picture. - But cant really apply the population mean of 2. Thus, I do have a question regarding this, I am not yet sure if you understand Swedish, but in the text/question it says: "Vart och ett...
  14. VECTOR

    Marginal effect with PROC GLIMMIX

    I don’tk ow anything about this; Thus my tip is maybe to try to make your question a bit clearer, might be right now that some people don’t really understand what you need help with. :-)
  15. VECTOR

    Excel - Statistics

    Answer 1: My Question was when I am calculating the mean, it’s not from the 100 numbers that I get by using the formula in excel- but the mean that we are given (2). Answer 2: σx̅ Is the standard deviation from the exponential distributaried numbers. So, what I am supposed to do now is...