In the below figure, cells B3 and B4 are formatted as date variables. Once the formula in cell B4 is run, what value will it take? December 25, 2020 \#\#\#\#\#\# #VALUE! 44190.00 You have data on daily sales for a major grocery store for an entire year. Column A contains the daily sales total in dollars. Column B contains the date, and Column C contains the day of the week: If you want to use the AVERAGEIFS() function to take an average of daily sales conditional on the day of the week being Thursday, which formula below uses the correct syntax? =AVERAGEIFS(A2:A366, C2:C366, 4) =AVERAGEIFS(B2:B366, A2:A366, "Thursday") =AVERAGEIFS(A2:A366, B2:B366, "Thursday") =AVERAGEIFS(A2:A366, C2:C366, "Thursday") You run a simple linear regression of high school dropout rates (0100%) as a unction of school expenditure per student (\$) and obtain an intercept estimate b0= 37.5. In words, what does the intercept estimate represent? If the school expenditure per student were $0, our model predicts that the dropout rate would be 87.5% All of the above A one unit increase in expenditures per student is associated with a 87.5% increase in the dropout rate There is a weak positive association between dropout rates and school expenditures