An automobile parts manufacturer uses a linear regression model to forecast the dollar value of the next years’ orders from current customers as a function of a weighted sum of their past-years’ orders. (Note: you can answer this question by making small additions to the Correlation and Model Error spreadsheet).ĩ. What positive correlation R would you need to have a model error of $15,000? Your boss asks you to keep working on improving the model until the new standard deviation of model error is $15,000 or less. Your first model has a standard deviation of model error of $25,000 at a correlation of R =. You use census tract data to develop a linear model. You are a data-analyst for a restaurant chain and are asked to forecast first-year revenues from new store locations. Use MS Solver and the Markowitz Portfolio Optimization Spreadsheet to Find the weighted portfolio of the two stocks with lowest volatility.Ĩ. Two stocks have the following expected annual returns: Hint: Use either the Algebra with Gaussians or the Markowitz Portfolio Optimization Spreadsheet.ħ. What is the standard deviation of a portfolio consisting of 70% Oil and 30% IT? Hint: Use the Standardization Spreadsheet.Ħ. Oil is plotted against IT on the (x,y) axis. Two stocks have the following expected annual returns:Īssume return data for the two stocks is standardized so that each is represented as having mean 0 and standard deviation 1. Hint: Use the Algebra with Gaussians Spreadsheet.ĥ. What is the Covariance of the two stocks? The Stocks prices have a small negative correlation: R = -.22. IT stock – expected return = 14% with standard deviation = 25% Oil stock – expected return = 9% with standard deviation = 13% Hint: Use the Typical Problem with NormSDist Spreadsheet.Ĥ. What is the probability that this much variation from the mean could have occurred by chance alone? In the population being studied, before taking any medicine the mean heart rate was 120 beats per minute, with standard deviation = 15 beats per minute.Īfter being given the medicine, a sample of 45 people had an average heart rate of 112 beats per minute. A population of people suffering from Tachycardia (occasional rapid heart rate), agrees to test a new medicine that is supposed to lower heart rate. A Gaussian Distribution that, in Phi notation, is written ϕ(109.A Gaussian distribution that, in Phi notation, is written, ϕ(109, 133.33).A Uniform Distribution with mean = 109 microns and standard deviation = 11.54 microns.A Uniform Distribution with mean = 109 microns and standard deviation =.Hint: Use the CLT and Excel Rand() Spreadsheet. What is the distribution of sample means? Its diameter is 100 microns, and all the wires produced have a uniform distribution of error, between -11 microns and +29 microns.Ī testing machine repeatedly draws samples of 180 wires and measures the sample mean. A carefully machined wire comes off an assembly line within a certain tolerance. Hint: Refer to the Excel NormSFunctions Spreadsheet.Ģ. What was their test score (rounded to the nearest whole number)? One student out-performed 97.4% of all test takers. A University admissions test has a Gaussian distribution of test scores with a mean of 500 and standard deviation of 100. Week- 4 Parametric Models for Regression (graded)ġ. Mastering Data Analysis in Excel Quiz Answer To get Mastering Data Analysis in Excel Quiz Answer | Week (1-3), Please click bellow: Week- 1
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |