Learning

Learning How To Find Probability In Microsoft MS Excel

Microsoft MS Excel is a tool used by many businesses for multiple purposes. Using different mathematical and statistical formulas in Excel is a great feature that eases life by doing complex calculations quickly. Probability is one such important statistical concept used in MS Excel that solves many business-related problems. Probability is a concept of Mathematics, of which most people are scared. But, a good understanding of probability is required to use it efficiently in Excel. In this article, we will explain how to find probability in Excel. But before that, let’s get an understanding of the probability concept.

What Is probability?

Probability is a mathematical concept that defines the possibility of the occurrence of an event. The probability value varies between 0 and 1, where 0 means no probability, and 1 means 100% probability. A higher value means more probability of occurrence of an event.

As an example, when we toss a coin, there are two possible outcomes, i.e., heads and tails. The probability of getting heads while tossing a coin is half, i.e., 50%, so is the probability of getting tails. This is the basic concept of probability, that is used in different applications of mathematics and statistics. The examples include the probability of rain on a specific day, probability of getting the number of sixes in an over in cricket, etc. The formula used to calculate the probability is as below:

Probability (P) = Number of possible occurrences / Total occurrences

Probability Terms:

Random Experiment

A random experiment is a process that gives an outcome whose occurrence is uncertain. To illustrate, rolling a dice, tossing a coin, picking a ball from a bag full of colored balls are random experiments.

Outcome

It is the result of the random experiment, which is not definite. As an example, there can be six possible outcomes when rolling a dice. Each outcome has a probability of occurrence, and the sum of all the probabilities is always 1. Below is the formula used to calculate the probability of each occurrence:

P(E)=1/Count of all the possible outcomes

In our example, the total possible outcomes are 6. Therefore, the probability of each number to appear on dice is 1/6 = 0.17.

Sample Space

All the outcomes of a random experiment together in the form of a set form the sample space. In our example of rolling a dice, {1,2,3,4,5,6} forms the sample space.

Let us try to understand these terms with example:

Random experiment: Rolling a dice

Sample space: {1,2,3,4,5,6}

Outcome: 1,2,3,4,5, and 6 are all the possible outcomes for the random experiment.

Probability of occurrence of 1, i.e., P(occurrence of 1) = 1/6 = 0.17

Similarly, P(occurrence of 2) = 1/6 = 0.17

P(occurrence of 3) = 1/6 = 0.17

P(occurrence of 4) = 1/6 = 0.17

P(occurrence of 5) = 1/6 = 0.17

P(occurrence of 6) = 1/6 = 0.17

Event

An event is defined as the combination of outcomes to define a single characteristic of the random experiment. In the above example, the occurrence of an even number while rolling dice is an event.

Sample space for occurrence of even number = {2,4,6}

Total sample space for the occurrence of any random number = {1,2,3,4,5,6}

P(occurrence of an even number) = P(occurrence of 2) + P(occurrence of 4) + P(occurrence of 6) = 1/6+1/6+1/6 =3/6 = ½ = 0.5

Type of events

The events can be of three types. These types are independent, dependent, and mutually exclusive. Let us understand these events in detail.

Independent events: Independent events mean the events are independent of each other and are not affected by the occurrence of other events. For example, tossing a coin three times. The outcome, i.e. heads or tails in each toss are independent of each other.
Dependent events: These events are dependent ones, i.e., the occurrence of an event depends upon the occurrence of previous event or events. For example, we draw 3 cards from a deck of 52 cards one after the other. This is an example of a dependent event because when one card is removed from the deck, it is left with 51 cards. Therefore, the probability changes for the second and third card.
Mutually exclusive events: Mutually exclusive means either of the events occurs, but not both at the same time. For example, getting head or tail while tossing a coin or getting a number when a dice is rolled. This is mutually exclusive because when a coin is tossed, the outcome can be either heads or tails, but it cannot be both at the same time.

Conditional Probability

The conditional probability of an event is defined as the probability of an event when the other event has already taken place. Conditional probability is the most fundamental concept of probability.

It can be defined with the below formula:

P(A|B) = P(A∩B)/P(B)

where P(A|B) is the find probability of event A when event B has already occurred.

P(A∩B) is the probability of both events A and B together.

P(B) is the probability of event B.

Example of Conditional probability

The probability of the occurrence of rain on a cloudy day is an example of conditional probability. Here, event A denotes the occurrence of rain, and event B denotes it is a cloudy day. This is an example of conditional probability, as we have to find the probability of raining when the day is cloudy.

Consider another example, rolling a dice. When we roll a dice, there is an equal probability of occurrence of any number from 1 to 6. But, if it is already given that number occurred in an even number, then it becomes the conditional probability where we will find the probability of getting a number when we know the number is even.

PROB Function Used in Excel

The probability can be calculated using a PROB function in excel. The PROB method can help in finding the probability for an event having a range of occurrences, each having a discrete probability value of the occurrence of an event.

The PROB function provides the probability value for an event having a range of occurrences, with an upper and lower limit of the occurrence of an event.

Below is the PROB function in excel:

Probability (P) = PROB(x_range, prob_range, [lower_limit], [upper_limit])

where x_range = an array showing different events

prob_range = an array showing the different probabilities of respective events in x_range array

lower_limit = lower limit value of the event

upper_limit = upper limit value of the event

Few points to note about the PROB function:

If any of the value in array prob_range <= 0 or > 1, then the PROB function will throw as error called #NUM!.
In case the sum of all the values in array prob_range != 1, then the PROB function will return the error #NUM!.
If the upper_limit value is left empty in the PROB function, then the PROB function will return the probability according to the lower_limit value.
If the size of arrays prob_range and x_range is different, then the PROB function throws an error #N/A.

Example of Using PROB Function in Excel

Consider an example of getting the probability of getting a sum of roll ten or more when two dice are rolled.

First of all, we will create a table in the excel showing the sum of the roll and their chances. In our case, we can get any sum of rolls from 2 to 12. There is only a single chance that the sum of 2 dices can be 2. This is only possible when both the dice show 1 when rolled. So, the chance of getting rolls 2 is 1. Similarly, the sum can be 3 when one dice shows 2, and the other shows 1, This can be possible in 2 ways, so the chance for rolls 3 is 2. Similarly, the chance for different rolls can be calculated using the below table:

	Dice 2
Dice 1		1	2	3	4	5	6
	1	2	3	4	5	6	7
	2	3	4	5	6	7	8
	3	4	5	6	7	8	9
	4	5	6	7	8	9	10
	5	6	7	8	9	10	11
	6	7	8	9	10	11	12

Chance can be calculated using the formula COUNTIF(D6:I11,K6), where D6, I11, and K6 denote the cells in excel.

Similarly, the probability can be calculated using Chance/36. Based on these values, the below table gets filled.

	A	B	C
1	Rolls	Chance	Probability
2	2	1	2.78
3	3	2	5.56
4	4	3	8.33
5	5	4	11.11
6	6	5	13.89
7	7	6	16.67
8	8	5	13.89
9	9	4	11.11
10	10	3	8.33
11	11	2	5.56
12	12	1	2.78

Now we will apply the PROB function to calculate the probability of getting a sum of rolls equal to or more than 10. Here x_range=Rolls, prob_range=Chance, lower limit=10, and upper limit=12.

Therefore, P(getting sum of rolls equal to or more than 10) = PROB($A$2:$A$12,$C$2:$C$12,10,12)

Where, $A$2, $A$12, $C$2, and $C$12 denotes the cells in excel.

Conclusion

Probability is an important concept that is used to solve various business as well as real-life problems. Therefore, it is necessary to understand the probability concept clearly. We have explained the probability in detail with an example and how to find the probability using an excel. We hope the information shared in this article is helpful to you and helps you grasp the information. If you want to learn data and related articles, visit cuemath for better insights and a deeper understanding.

Learning

First-Time Buyer’s Guide to the UK Property Market

Entering the UK property market as a first-time buyer can feel both exciting and daunting. The process is filled with potential pitfalls and complex decisions, but with the right guidance, it can be navigated smoothly. The estate agents in Yorkshire demystify the journey from the initial decision to buy a home to the moment you step over the threshold of your new property.

Understanding Your Financial Position

The first and perhaps most crucial step in the home-buying process is understanding your financial situation. This includes assessing your savings, income, and current debts. Here’s how you can prepare:

1. Deposit: Generally, you’ll need at least 5% of the property price as a deposit, though aiming for 10% or more can provide better mortgage rates.

2. Income and Expenses: Use a budget planner to assess your monthly income against your expenses. This will help you understand how much you can afford in monthly mortgage repayments.

3. Credit Score: Lenders will evaluate your credit score to determine your mortgage eligibility. So it’s important to have a good credit score, and you should work on it if required.

4. Mortgage Options: Speak to a mortgage advisor to understand different types of mortgages, such as fixed-rate, variable-rate, and help-to-buy schemes.

Getting a Mortgage Agreement in Principle

A Mortgage Agreement in Principle (AIP) is a statement from a lender indicating how much they’ll likely lend you. You will be a more attractive buyer with an AIP as it shows sellers you’re serious and financially prepared.

Deciding What You Want

Before you start viewing properties, it’s essential to know what you’re looking for. Consider the following factors:

1. Location: Proximity to work, schools, public transport, and amenities are key. Research neighbourhoods to find the best fit for your lifestyle.

2. Property Type: Decide whether you want a flat, terraced house, semi-detached, or detached property. Each has its pros and cons.

3. Must-Haves: Make a list of non-negotiables, such as the number of bedrooms, garden size, and parking facilities.

4. Future Proofing: Consider your future needs. Are you planning to start a family? Do you need space for a home office?

Starting the Property Search

With a clear idea of what you’re looking for, you can begin your property search. Here are some tips:

1. Use Online Portals: Websites like Rightmove, Zoopla, and OnTheMarket are excellent starting points. Set up alerts to get notified of new listings that meet your criteria.

2. Visit Estate Agents: Register with local estate agents who can provide insights into the market and inform you of new properties before they’re listed online.

3. Attend Viewings: Don’t rush this part. Visit several properties to get a feel for what’s available in your price range.

Making an Offer

Once you find a property you love, it’s time to make an offer. Here’s how to approach it:

1. Research: Check the selling prices of similar properties in the area to gauge a fair offer.

2. Negotiate: Don’t be afraid to negotiate. The starting point is most usually the asking price.

3. Conditions: You might include conditions in your offer, such as the inclusion of certain fixtures or a specific moving date.

The Legal Process

If your offer is accepted, the legal process begins. You’ll need a solicitor or licensed conveyancer to handle the legalities. Here’s what to expect:

1. Conveyancing: This is the legal transfer of property ownership. Your solicitor will handle this, including conducting searches, dealing with the Land Registry, and transferring the funds.

2. Surveys and Inspections: Arrange for a property survey to check for structural issues. There are different types of surveys, from basic condition reports to full structural surveys.

3. Mortgage Finalisation: Once the survey is complete and satisfactory, your mortgage can be finalised.

4. Exchange of Contracts: This is when the sale becomes legally binding. You’ll pay your deposit at this stage.

5. Completion: On the agreed completion date, the remaining money is transferred, and you receive the keys to your new home.

Moving In

Moving day can be hectic, but planning can ease the stress:

1. Hire a Removal Company: Book a reliable removal company well in advance. Discover the best deals by getting quotes from multiple companies.

2. Pack Strategically: Label your boxes by room and keep essential items accessible.

3. Notify Utilities and Change Address: Inform your utility providers of your move date and update your address with banks, the DVLA, and other important institutions.

Settling In

Get settled. Introduce yourself to the neighbours, familiarise yourself with the local area, and really start to make the place your own.

Here are a few final tips:

1. Safety Checks: Make sure that your smoke alarms and carbon monoxide detectors are working, and make sure that you know where the gas and electricity meters are located.

2. Maintenance Plan: Keep a record of the smooth functioning of your new home with a maintenance schedule, complete with regular checks and seasonal tasks.

3. Personal Touches: Add personal touches to make the space feel like home. This can be from putting up family photos or redoing the decoration in your rooms.

Conclusion

Buying your very first home in the UK is most definitely a milestone, difficult and full of challenges but rewarding in the end. Such a philosophy guides you in understanding finances and knowing what you want to achieve from detailed research, and seeking professional advice that confidently helps you navigate the property market. Yes, the journey may have its hurdles, but in the end—owning your own home—the reward will be worth the effort. Welcome to your new chapter!

Learning

5 Health Benefits of Regular Pedicures

There’s nothing quite like a pedicure to keep your feet looking and feeling their best, but did you know that pedicures do more than simply enhance the appearance of your feet? Many people don’t realize that regular pedicures can come with a wide range of health benefits that can promote the well-being of your feet, so here are some ways that your routine pedicure keeps both your toenails and feet in the best condition possible!

Smoother Skin

One of the biggest misconceptions about pedicures is that they only cater to and look after your toenails. While you’ll definitely be leaving each session with a fresh coat of nail polish, your pedicure can also do wonders for the health of your skin. Aside from trimming and shaping your nails and cuticles, you’ll notice that your nail technician also dedicates a few steps to the skin of your feet.

After inspecting your feet and looking for any issues or imperfections that may need to be addressed, your technician will work on an exfoliating scrub to remove any dead skin cells. This step may also be aided by a foot file, which can be used to buff away any calluses and other problem areas manually.

Softer Skin

After your nail technician addresses all the problem areas of your feet and removes any unwanted dead skin cells, he or she will often massage in a moisturizing product, such as lotion, cream, or butter, to ensure that your skin is properly moisturized. These products contain skin-loving ingredients that will ensure that your feet have everything they need to look and feel their best so that you can walk out of your pedicure with a renewed sense of confidence.

Healthier Nails

After your pedicure session, your nails will not only look better due to the fresh coat of nail polish, but they’ll also be healthier and stronger. This is because your nail technician takes their time to ensure that your nails are properly looked after through steps that include deep cleaning, nail trimming, nail filing, and cuticle care. All of these things work together to prevent issues like ingrown nails from occurring, all the while improving the appearance of your nails.

Increased Blood Circulation

While the specific steps included in your pedicure will depend on the beauty salon, most pedicures will have a massage step somewhere in the mix. One of the often overlooked benefits of these massages is the increased blood circulation, which can deliver more nutrients and oxygen to your feet and nails, promoting their health and appearance. Aside from that, better blood flow means reduced tension and soreness, as well as better distributed heat throughout your body.

Reduced Infections

A significant amount of dirt and bacteria can build up on your feet without you even realizing it, but pedicures can be a great way to prevent these from happening in the first place. The exfoliation step of a pedicure removes dead skin cells as well as all the debris that may have accumulated underneath, and the deep cleaning of your toenails and cuticles also gets rid of any impurities that may have slipped beneath them, which can stop infections from happening.

These are some of the many health benefits that you can look forward to at your next pedicure appointment. However, it’s worth noting that you need to book regular sessions to truly reap all the rewards. This can be difficult, especially when you don’t feel like driving to your nearest nail salon after a long day, but the good news is that you can enjoy the salon experience in the comfort of your own home with a home pedicure service.

Learning

Commercial Boiler Installation Services London

For businesses in the bustling city of London, having a reliable heating system is crucial. Whether you’re opening a new office, expanding your current premises, or simply upgrading an outdated system, commercial boiler installation services for businesses in London are essential to ensure your operations run smoothly and efficiently. Proper installation and maintenance of commercial boilers can make a significant difference in energy efficiency, cost savings, and the overall comfort of your workspace.

The Importance of Professional Installation

When it comes to installing a commercial boiler, professional expertise is paramount. Here’s why:

Efficiency and Performance: Professional installation ensures that your boiler operates at peak efficiency, reducing energy consumption and lowering utility bills. A well-installed boiler can effectively meet the heating demands of your business without unnecessary energy waste.
Safety: Commercial boilers are complex systems that require precise installation to operate safely. Professional installers adhere to stringent safety standards and regulations, minimizing the risk of accidents and ensuring the safety of your employees and premises.
Compliance with Regulations: Commercial properties are subject to various building codes and regulations. Professional installers are well-versed in these requirements and ensure that your boiler system complies with all local laws and standards.
Longevity and Reliability: Proper installation is critical to the longevity and reliability of your boiler. A professional installation can prevent common issues such as leaks, pressure problems, and system failures, ensuring that your boiler runs smoothly for years to come.

Key Considerations for Commercial Boiler Installation

When planning for a commercial boiler installation, several factors need to be considered:

Type of Boiler: The type of boiler you choose will depend on your business’s specific needs. Options include gas boilers, oil boilers, and electric boilers, each with its own set of advantages. Consulting with a professional can help you determine the best choice for your business.
Sizing and Capacity: The boiler’s size and capacity must match the heating demands of your commercial space. An undersized boiler will struggle to meet your needs, while an oversized one will lead to inefficiencies and higher costs.
Location: The placement of your boiler affects its efficiency and accessibility for maintenance. Professional installers can help you choose the optimal location for your boiler.
Integration with Existing Systems: If you’re upgrading or replacing an existing boiler, it’s essential to ensure compatibility with your current heating system. Professional installers can seamlessly integrate the new boiler with your existing setup.

Choosing the Right Installation Service

Selecting the right installation service provider is crucial to the success of your boiler installation project. Consider the following when making your choice:

Experience and Expertise: Look for a provider with a proven track record in commercial boiler installations. Experienced installers can handle the complexities of commercial systems and provide high-quality workmanship.
Reputation: Check reviews and testimonials from previous clients to gauge the provider’s reliability and customer satisfaction.
Comprehensive Services: Choose a provider that offers a full range of services, including installation, maintenance, and repair. This ensures that all your boiler needs are met by a single, trusted source.

In London, ROWLEN is a reputable name known for delivering top-notch commercial boiler installation services. Their team of experts is dedicated to providing efficient, safe, and compliant installations tailored to the unique needs of businesses.

Conclusion

Investing in professional commercial boiler installation services for businesses in London is essential for ensuring efficiency, safety, and long-term reliability. By choosing an experienced and reputable service provider like ROWLEN, you can rest assured that your heating system will be installed correctly and maintained to the highest standards. Proper installation not only enhances the performance of your boiler but also contributes to the overall comfort and productivity of your business environment.

SEE ALSO: