"I have a spreadsheet of results from a survey I have been preforming. In Column I there are results where 1 is yes and 0 is no. I need to be able to calculate the percentage of Yes answers in a separate tab, how do i do this?"
The first thing is to count the total amount of values, using the COUNT function. You then need to find the amount of times 1 comes up, which you can do by just using the SUM function. Then divide the result of the SUM by the result of the COUNT and format the result as a percentage. To specify the Sheet from another sheet, you put the sheet name followed by an exclamation mark and then the cell references.
Let's say your values were in the cells from I2 to I25 on Sheet1, then your final formula with the functions could be as follows:
=SUM(Sheet1!I2:I25)/COUNT(Sheet1!I2:I25)
The results of formulas that you type in are outputs in Excel. If you do filters, the results you get are outputs. Charts are an output. If you print anything from Excel, that is an output.
you first have to culculate equilibrium level of income.
Yes
Personal Income = Disposable Income + Personal Savings
1% = 0.01 and so 0.01 times 1,000,000 = 10,000
use a spreadsheet like excel, or use a pencil
Formula wooksheet
Circumference of any circle = 2*pi*radius or diameter*pi
The answer depends on the maxmum value or the longest [text] string that the characteristic can take.
The Live Preview feature.
It caused some multiplications to return erroneous results. The multiplications included 77.1*850, 5.1*12850, and 10.2*6425. They should return results of either 65,535 or 65,536 but in Excel 2007 they returned a result of 100,000 instead.
Gross Spread for Banks = (Net Markup Income/Gross Income)