Use the Consumer Food database from "Excel Databases.xls" on Blackboard. Use Excel to develop a multiple regression model to predict Annual Food Spending by Annual Household Income and Non-Mortgage Household Debt. Assume a 5% level of significance. What is the dependent variable in the study? O Non-Mortgage Household Debt O 200 households in the Consumer Food database O Annual Food Spending O Annual Household Income

***ONLY QUESTION 6***  House prices are $1,000 each

15. Diameter of Douglas Fir Trees The diameter of the Douglas fir tree is measured at a height of 1.37 meters. The S following data represent the diameter in centimeters of a random sample of 12 Douglas firs in the western Washington Cascades. 156 162 147 173 147 190 130 101 159 113 181 109 Source: L. Winter. "Live Tree and Tree-Ring Records to Reconstruct the Structural Development of an Old-Growth Douglas Fir/Western Hemlock Stand in the Western Washington Cascades." Corvallis, OR: Forest Science Data Bank, 2005. (a) Obtain a point estimate for the mean and standard deviation diameter of a Douglas fir tree in the western Washington Cascades. (b) Because the sample size is small, we must verify that the data come from a population that is normally distributed and that the data do not contain any outliers. The figures show the normal probability plot and boxplot. The correlation between the tree diameters and expected z-scores is 0.982. Use Option 1 or Option 2 to determine if the…

Use Table 12-2 to calculate the present value (in $) of the ordinary annuity. (Round your answer to the nearest cent.) Nominal Annuity Payment Payment Frequency Time Interest Present Value Period (years) Rate (%) Compounded of the Annuity $4,000 every year 20 4 annually