0
The FREQUENCY function would do it. You could have your list of actual scores in a column and then create a list of each score just once, and put them into a column. Then beside that you select the corresponding blank cells and would put the FREQUENCY function in the first cell, using the references to your original scores and possible scores as the arguments. Then press Ctrl - Shift - Enter to fill out all the cells as an array formula. So say your actual scores were in the cells A2 to A50, and all possible scores were in B2 to B100, the in C2 you would put:
=FREQUENCY(A2:A50,B2:B100)
It would then appear as:
{=FREQUENCY(A2:A50,B2:B100)}
In column C a value for the amount of all scores would be listed beside each score in column B.
Wiki User
∙ 8y ago
Add your answer:
Earn +20 pts
Why is MS Excel is called Excel?
MS-Excel is a powerful worksheet & you calculate , syncronize many hard calculation, so MS-Excel is called Excel.
Why do you use MS Excel?
Many people use Microsoft Excel to perform calculations. They also use it to establish databases for their business. Excel makes people efficient.
What peoeple use Microsoft Excel?
Excel can be used by all sorts of people. Excel has a huge range of things it can do, which makes it useful to many people, from business people to ordinary people, from children to any age.
Is the greyhound dog smart?
.Yes,many Greyhounds excel as therapy dogs. Others score well in agility and obedience
How many minutes are in 8 hours how to calculate in excel?
there are 480 mins in 8 hrs 60mins x 8
Why do you use Excel for financing?
Excel has a wide range of uses for anything to do with numbers. Finances are based on numbers. Along with standard calculations Excel has lots of specialised financial functions built into it. These enable people to do things like calculate payments for loans, returns on investments, depreciation and many other financial things. Excel can also be used to plan things that companies or individuals will do with their finances. So it has many uses in relation to financing.
How could one calculate credit score on Privacy Matters online service?
One can use the credit score estimator on the Privacy Matters website to calculate their credit score. Just follow the simple on screen instructions asking how many credit cards, loans etc one has and it will produce a credit score.
How did people calculate before Excel was developed?
Excel was not the first spreadsheet application. VisiCalc was the first, which came out in 1979. Excel was not launched until 1985. Between VisiCalc and Excel there were also other spreadsheet applications, most notably Lotus-123.Prior to VisiCalc, there would have been calculators and other ways of calculating things on a computer. The electronic spreadsheet was based on the paper-based spreadsheet, which business people used to make calculations. So there were many ways of doing calculations before Excel.
How many people wish to learn Microsoft Excel?
There is no way to know that. People all around the world do courses in Excel all the time and there are always new people doing them.
How many people does the Excel center seat?
There are many places known as "The Excel Centre". You will need to specify which one you mean in order for your question to be answered.
Why do you need first have to understand how to calculate math using the paper and pencil method before you can write a formula in Excel?
Many formulas are mathematical, so if you can't do maths on paper, then you won't be able to do it in Excel.
What is the highest SAT score ever achieved?
Perfect score, many people have achieevd it before.
