0
How do you find the mean mark on a class in a bar chart on Excel?
Wiki User
∙ 14y ago
Excel does not automatically calculate and display the mean in a bar chart. You can add the mean following these steps:
- Enter your data points (EXAMPLE: A1:A23).
- In cell A24 (or whatever cell is at the bottom of your data), enter the formula =AVERAGE(A1:A23).
- Highlight all the cells (A1:A24) and use that as the data to create your chart.
- Format your chart as you like.
- Observe that the last entry in the chart will be the MEAN.
If the bar chart already exists and you do not have access to the original in Excel, then you will need to add up all the values of all the bars and divide by the number of bars on the chart.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What is the class mark of class interval 10.5-17.5 and class size 7?
Class mark = (10.5 + 17.5)/2 = 14Class mark = (10.5 + 17.5)/2 = 14Class mark = (10.5 + 17.5)/2 = 14Class mark = (10.5 + 17.5)/2 = 14
What does it mean when a person's mark is the same as the class average?
Simply that the person performed as well as the rest of the class.
How can you apply for duplicate mark sheet of class 10 of 1992-93?
by name
What is the 10th class mark sheet Sr.no meant by?
The serial number is also the mark sheet number. So when asking for the serial number you will input the mark sheet number.
If you have an overall mark of 67 percent your final exam is worth 40 percent What mark do you have to get on your final exam to come out of the class with a 70 percent as your mark?
You need at least a 75% on your exam.
What are the differences between Pie Chart and a histogram with merits and demerits?
i think the major defrince in calculation pie chart use degree by converting percent but histogram use frequncy and class mark umm and in their drawing style
Is a puncation mark a character in excel?
Yes.
What is the class mark of class interval 10.5-17.5 and class size 7?
Class mark = (10.5 + 17.5)/2 = 14Class mark = (10.5 + 17.5)/2 = 14Class mark = (10.5 + 17.5)/2 = 14Class mark = (10.5 + 17.5)/2 = 14
What does ctrl accent mark do in excel?
It displays the formulas in your spreadsheet.
How do you type a check mark in an adobe PDF form?
Open MS EXCEL, click on insert, symbol, find the check mark symbol and click on Insert. Copy the cell, go to Adobe form and paste.
How do you type check mark symbol in adobe PDF?
Open MS EXCEL, click on insert, symbol, find the check mark symbol and click on Insert. Copy the cell, go to Adobe form and paste.
What has the author Mark Dodge written?
Mark Dodge has written: 'Running Microsoft Excel for Windows 95' -- subject(s): Business, Computer programs, Electronic spreadsheets, Microsoft Excel (Computer file) 'Microsoft Excel 2010 inside out' -- subject(s): Microsoft Excel (Computer file), Business, Computer programs 'Running Microsoft Excel 97' -- subject(s): Business, Computer programs, Electronic spreadsheets, Microsoft Excel (Computer file)
How do you mark your sea chart in wind waker?
first you need bait, then go where you want mark your chart, look for fish jumping up and down, wait until he get near and give him the bait. do it to all isles
WHAT IS THE CLASS MARK OF CLASS INTERVAL 40-50?
90
How do you use longitude in a sentence?
He noted the latitude and longitude, then made a mark on the chart.
What are the components used in the frequency distribution?
class limit. class boundary. class mark. class widh.
What can not go into a Excel workbook file name?
Special characters, such as the asterisk and the question mark.
