This is NOT a team effort. A Team effort is called cheating!!!! Ask ME if you have a question. Make sure you upload spre
Posted: Wed May 04, 2022 12:44 pm
This is NOT a team effort. A Team effort is called cheating!!!!
Ask ME if you have a question. Make sure you upload spreadsheet to
BlackBoard. You may use Excel and/or MegaStats for any questions
and must show all your work. I must be able to see your formulas
and/or output The assignment is open book, open notebook. Except
for terminating decimals and dollar amounts, all answers should be
rounded to four (4) decimal places. Dollar amounts may be rounded
to pennies (cents). Each question is 3 points each. Due Monday, May
02, NOON, 12:00 PM. 1) The average annual cost of tuition for all
49 public 2 year colleges (Alaska did not submit data) for the
academic year 2020-2021 is $4,571 according to the “Trends in
College Pricing 20201 ” report of the College Board. The College
Board conducted the study using all available statewide data and
showed a standard deviation from all 49 states of $1,740. Assume
the data is normally distributed. a) In what range (lower end and
upper end) would 90% of all this data fall? b) In what range (lower
end and upper end) would 98% of all this data fall? c) How much
would tuition need to be for the 90 th percentile? d) How much
would tuition be to be in the lowest 10%?
Ask ME if you have a question. Make sure you upload spreadsheet to
BlackBoard. You may use Excel and/or MegaStats for any questions
and must show all your work. I must be able to see your formulas
and/or output The assignment is open book, open notebook. Except
for terminating decimals and dollar amounts, all answers should be
rounded to four (4) decimal places. Dollar amounts may be rounded
to pennies (cents). Each question is 3 points each. Due Monday, May
02, NOON, 12:00 PM. 1) The average annual cost of tuition for all
49 public 2 year colleges (Alaska did not submit data) for the
academic year 2020-2021 is $4,571 according to the “Trends in
College Pricing 20201 ” report of the College Board. The College
Board conducted the study using all available statewide data and
showed a standard deviation from all 49 states of $1,740. Assume
the data is normally distributed. a) In what range (lower end and
upper end) would 90% of all this data fall? b) In what range (lower
end and upper end) would 98% of all this data fall? c) How much
would tuition need to be for the 90 th percentile? d) How much
would tuition be to be in the lowest 10%?