__________ is a structure that transports sugar around plants.

Quick Problems (25 problems, 1 pt each)

Save your Excel file as “FirstInitialLastName – Midterm Exam.xlsx” For example, mine would be named “TLekwijit – Midterm Exam.xlsx” Submit Your Excel File. Failure to submit your Excel file for the Midterm Exam will result in an automatic 50% penalty on your final score.

If the total sum of squares (SST) is 2,640.5 and the sum of squares due to error (SSE) is 715.3, what is the r-squared value? Please round your answer to four decimal places.

At Erewhona, the average time customers spend waiting for a smoothie is 10 minutes, with a standard deviation of 2.5 minutes. Assuming wait times are normally distributed, what wait time (in minutes) corresponds to a z-score of +2.0? Round your answer to the nearest integer if necessary.

Use the Logit sheet. The Department of Health Services aims to predict whether an individual will receive an annual flu shot using a logistic regression model based on community health survey data. As predictors, the model considers age (in years), income (in thousands), health insurance coverage (1 if insured, 0 otherwise), and length of residence (measured by the number of years the person has lived in their current zip code). The Logit sheet contains the descriptive statistics and logit regression results. Based on these results, interpret the effect of “health insurance coverage” on the odds of receiving a flu shot.

At the Nevermore Library, study sessions average 52 minutes with a standard deviation of 8 minutes. The session duration follows a normal distribution. Using the empirical rule, what percentage of sessions last between 36 minutes and 76 minutes? Please answer in one decimal place without the % mark.

Use the Probit sheet. The Department of Health Services aims to predict whether an individual will receive an annual flu shot using a probit regression model based on community health survey data. As predictors, the model considers age (in years), income (in thousands), health insurance coverage (1 if insured, 0 otherwise), and length of residence (measured by the number of years the person has lived in their current zip code). The Probit sheet contains the descriptive statistics and probit regression results. Based on these results, interpret the coefficient (B) on “income”. (Hint: Use the term “z-score in favor of receiving a flu shot”)

Use the InsurancePremium sheet. Develop a multiple linear regression model to predict the monthly car insurance premium based on the age of the driver and the type of car (sedan, SUV, or sports car). Use sedan as the baseline. What is the estimated monthly insurance premium for a 21-year-old driver with an SUV? Please round your answer to the nearest integer.

 Which hormone can cause decreased sexual desire when present in high but not low levels?