473,320 Members | 1,872 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Probability and distribution Problem?

1
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.
Jun 21 '14 #1
1 1598
Rabbit
12,516 Expert Mod 8TB
The phrase random uniform distribution doesn't make sense. If it's uniform, there's no randomness. If it's random, there's no uniformity.

I don't know what it is you're actually looking to do. A distribution is just a description of the probability of an event. Which you've already done. You will need to be clearer on what your goal is to get more help.

Also, you have no 3 value in your outcomes. Are you saying that 3 never happens?

To figure out the probability of any one number, just let x be the probability of a single occurrence, apply your multipliers, and the sum of all the numbers should equal 1. If you solve for x, that gives you the probability of any one number.
Jun 22 '14 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Greg Smith | last post by:
I have a C# Windows application that I am distributing to a large number of machines. On some of the machines the MDAC is not adequate to run the application. After installing the current MDAC...
1
by: Curious | last post by:
Hi, I require a library to generate random values from distribution functions like Poisson, Binomial, Bernoulli, etc. Is there such a libarary available in .Net or can someone give me some...
5
by: steve_marjoribanks | last post by:
This isn't strictly an XML problem but I thought someone might be able to help! As part of my degree I am working on a new data format for use in the geotechnical engineering domain. The data...
11
by: Tomi Lindberg | last post by:
Hi, I'm trying to find a way to calculate a distribution of outcomes with any combination of dice. I have the basics done, but I'm a bit unsure how to continue. My main concern is how to make...
8
by: Elliot Temple | last post by:
Problem: Randomly generate 10 integers from 0-100 inclusive, and sum them. Do that twice. What is the probability the two sums are 390 apart? I have code to do part of it (below), and I know how...
4
by: MikeMikeMike | last post by:
Hi, I've made som applications with VS 2005 and now I try to distribute them to another machine. This aint working unless that machine has also got VS 2005 installed. I get an error that looks...
8
by: Surya Dutt | last post by:
Hello, Did someone happen to come accross and algorithm or a C++ program that simulates the Smith Collge Diploma problem? "At Smith College, the graduation exercises traditionally proceed as...
8
by: David Barr | last post by:
I am brand new to Python (this is my second day), and the only experience I have with programming was with VBA. Anyway, I'm posting this to see if anyone would be kind enough to help me with this...
11
by: Alex | last post by:
Hi everybody, I wonder if it is possible in python to produce random numbers according to a user defined distribution? Unfortunately the random module does not contain the distribution I need...
25
TheSmileyCoder
by: TheSmileyCoder | last post by:
I have a table of names, with 2 fields in it, dblProbability and txName, where dblProbabilty is the relative probability that the Name in that row should be selected. How can I get 1 random name from...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.