- 1 Open The Excel Data Set Homepricel Xls From The Course D2l Site Use Excel To Work Each Of The Following Problems A 1 (268.44 KiB) Viewed 48 times
1. Open the Excel data set HomePricel.xls from the course D2L site. Use Excel to work each of the following problems. A. The variable "Sqrft” is the square footage of each of the listed homes. Calculate the Standard Deviation, Minimum value, Maximum value. B. The variable “Price” is the price (in $1,000) of each of the listed homes. Calculate the following summary statistics using this sample for the variable Price: Mean, Median, Standard Deviation, Minimum value, Maximum value. C. The variable “Colonial” is categorical. It is coded in the Excel sheet with a value of 1 if the listed house is a Colonial style house and with a value of 0 otherwise. Calculate the proportion of houses that are Colonial style. Use PhStat for problem 2. 2. Suppose that the monthly number of units sold is normally distributed with a mean of 11,400 and a standard deviation of 586. A. Determine the probability that the number of units sold will be less than 10,000. B. Determine the probability that the number of units sold will be greater than 12,000. C. Determine the probability that the number of units sold will be between 10,000 and 12,000. D. 25% of the time, number of units sold will be less than what value? E. 40% of the time, number of units sold will be greater than what value? F. 90% of the time, number of units sold will be between what two symmetric values?