Microsoft excel statistics

Sheet1

		Input		Targets
	Price Gold USD/oz=	1200	>	1261
	Level of S&P500 Index=	5000	<	1895
	Days of sell signal=	3	>=	3
	Yoli! Do the following==>
	Gender =	woman		Athelete's Body fat? Y of N		Y
	Weight =	180
	Height =	68
	Age =	68

Final Prob. 7) One evening your sister-in-law Yolanda, who you fear, tells you that she has developed a new investment strategy. She only holds gold bullion or Shares in an S&P500 index mutual fund, depending on the prices of these two investments. If the value of gold goes over $1261/oz. or the S&P index is below 1895 she sells gold and buys S&P Index; otherwise she holds her current position. I suggest, rather timidly, that with market volatility being high, she might also consider waiting for the conditions to remain the same for at least 3 trading days before executing the S&P500 purchase. She uncharacteristically agrees and even smiles at me. Yolanda asks you to create a logical function using the IF(), AND(), and OR() functions in Excel to tell her explicitly to either "Hold Current Investment Position, Yoli!" or "Sell Gold and Buy S&P Index, Yoli!". Base the logic on the three elements discussed above. Create your logical function in the model below. (Hint: The OR will be used for the first 2 conditions--1261 and 1895-- and AND will be used for the results of the OR and 3 days.)

Final Prob. 2) One of the best known calculations of Basal Metabolic Rate is the original Harris-Benedict equations for men and women1. According to Wikipedia..."Basal Metabolic Rate is the amount of energy expressed in calories that a person needs to keep the body functioning at rest. Some of those processes are breathing, blood circulation, controlling body temperature, cell growth, brain and nerve function, and contraction of muscles. Basal metabolic rate (BMR) affects the rate that a person burns calories and ultimately whether you maintain, gain, or lose weight." Woman: BMR = 655 + ( 4.35 x weight in pounds ) + ( 4.7 x height in inches ) - ( 4.7 x age in years ) Man: BMR = 66 + ( 6.23 x weight in pounds ) + ( 12.7 x height in inches ) - ( 6.8 x age in year ) Create a calculator that permits data entry of gender (Woman or Man), weight (pounds), height (inches.), and age (years) in cell C1-C4, respectively. In cell C6 place the formula calculation for BMRs. In cell A6 place a logical formula that results in either "Ms. your BMR is =" if the calculation is for a woman or "Mr. your BMR is =" depending on the entry C1. Suppose you also ask if an individual has the body fat of an athlete. In Cell E1 insert the text: "Athlete's Body Fat?--"Y" or "N". The answer is placed in G1--either "Y" or "N". If the answer is "Y", the formula in C6 should be multiplied by a factor of 1.25, otherwise it remains the same. The multiplication should occur due to a logic statement. Restrict all entries to integer values: e.g. 180 lbs., 68 inches, and 68 years. Use these in your model. Source: https://en.wikipedia.org/wiki/Basal_metabolic_rate