Vora_Sarah_HW1

.xlsx

School

University of Texas, Dallas *

*We aren’t endorsed by this school

Course

6301

Subject

Statistics

Date

Apr 3, 2024

Type

xlsx

Pages

48

Uploaded by GeneralFoxMaster1044 on coursehero.com

H If you have any question DO NOT change the structure of Follow the su Name the f Problem Set 1 Set 2 Set 3 Set 4 Total You must use Excel functions when Do not round-off your answ DO NOT change the structure of the shee Before uploading, double-check you are uploading the correct f is FINAL. NO e-mailed 5-point (non-refundable) penalty for missing these two steps.
HOMEWORK 1 ::: 20 Points INSTRUCTIONS ns regarding your HW grade, please contact the TA f the sheets. That is, do not add or delete columns / rows. ubmission guidelines (see eLearning). file as: LastName_FirstName_HW1 Last Name Vora First Name Sarah NetID SXV190066 Do not make any changes here Points Earned Comments 3 6 5 6 20 0 n available. The work must be done within the cells themselves. wers , but format the cells to show 4 decimal places. ets. That means do not add or delete columns or ro file. Do not upload while the file is still open. Once uploaded, your or late submissions will be accepted.
ows. D O N OT ch an ge th e str uc tur e of th e sh ee ts. Th at m ea ns do no t ad submission
ad d or de let e col u m ns or ro ws . `
Name : Sarah Vora 3 0 0.4 Use AVERAGE to find the mean μ 0.4 0.4 Use STDEV.P to find the standard 0.4 Use the formula (see your notes) 0.3 Use COUNT function to find the p 0.8 The variance of the population (c 0.3 The std dev of the population (ca Fall 2023 Population X 174 162 159 175 161 158 175 161 158 179 166 171 154 165 170 The heights of all the students (in below as Population X. Use the ap first three answers. For the last th and use that information to answ Use VAR.P to find the variance σ 2 keep out of this area DO NOT change the structure of the sheets. That means d K E E P T O T H E R I G H T O F T H I S B A R .
157 178 168 152 136 142 160 180 150 Total 3911
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help