Closed Thread
Results 1 to 2 of 2

Probability and distribution Problem?

  1. #1
    Registered User
    Join Date
    06-21-2014
    Location
    toronto
    MS-Off Ver
    2014
    Posts
    2

    Probability and distribution Problem?

    I have to formulate this in excel and was wondering if anyone could help me with the formulas.

    It has also determined that the number of repair claims filed each week is a random variable
    which can take values 1, 2, 4, 5, 6, 7, 8, 9. The probability of having 1 or 9 claims in a week is
    equal. The probability that there are 2, 6, 7 or 8 claims in a week is twice the probability of
    there being a single claim. The probability that there are 4 claims in a week is twice the
    probability that there are 2 claims in a week. The probability that there are 5 claims in a week is
    6 times the probability that there is a single claim in a week. The dollar amount per claim fits a
    normal distribution with a mean claim amount of $2000 and a standard deviation of $400.

    In addition to repair claims, the company also receives claims for cars that have been “totaled”
    and cannot be repaired. There is a 20% chance in any week of receiving this type of claim. The
    claims for “totaled” cars cost has a uniform distribution, in the range $10000 to $35000. Not all
    repair claims are legitimate: 1% of the repair claims filed are rejected. Of the “totaled” claims
    filed, 0.5% of them are rejected.

    I'm not sure how to make the formulas for paragraph 1. And then I don't know how to incorporate the probability into the random uniform distribution and how to incorporate the reject variable.

    Any help would be greatly appreciated.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,879

    Re: Probability and distribution Problem?

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Plotting probability distribution?
    By PUH in forum Excel General
    Replies: 9
    Last Post: 11-06-2014, 12:58 AM
  2. Probability Distribution VBA function
    By excelmaniac in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-02-2011, 06:32 PM
  3. Lognormal Probability Distribution in Excel 07
    By VigCS in forum Excel General
    Replies: 1
    Last Post: 10-10-2009, 03:21 PM
  4. type of probability distribution
    By shruthi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-09-2006, 08:59 AM
  5. Autocreating probability distribution
    By Zerex71 in forum Excel General
    Replies: 4
    Last Post: 07-27-2006, 01:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1