Statistic assignments, answering 3 questions using excel and word, then combine them into pdf, I will upload two files
MA460 Finite Element Methods Page 1 of 2 RMIT University, School of Science, Mathematics Math2114 – Numerical Methods & Statistics for Engineers Assignment 3 (Stats) Due: Friday 17:00 pm, 11th October (Week 11), Semester 2, 2019 This assignment contributes 4% towards the assessment for the subject. The Assignment reports should be in the PDF format, and must be individual and submitted online via course Canvas under the tab: Assignments. Late assignments will not be marked, unless a special consideration is granted prior to the due day for a later submission. Instructions: - The following list of questions is based on the material covered in the text book Chapters 7, 8 and 9. Please work through these problems and present your calculations and/or Excel output where required. - You will need to create a Microsoft Word document, copy your Excel output in the form of tables into the word document, or take a screen shot and then insert the image into the word document, as well as present your written answers to the questions in the report. - At the completion of the report, save it to a .pdf file and submit it online to the Canvas. - Total 10 marks. This week, we’re going to look at some of the responses gathered by a class survey. You can find this in ClassSurvey.xlsx. There are two worksheets: • Responses is the main sheet and contains a cleaned copy of the survey responses • Hours Studied contains two columns showing the hours studied, one column for civil engineering students and one for chemical engineering students. Question 1 (Sample Size required 1.5 marks) Let’s examine the proportion of women in this class vs men. 1a). Find the 95% confidence interval for the proportion of this class who are women. (0.5 marks) HINT: Create a pivot table, and exclude observations where the response was either blank or “Prefer not to say” HINT: Remember, the variance for the proportion is given by ??(1 − ??). This can be used to calculate Standard Deviation, and Standard Error. HINT: Because ?? is known, use Z critical values, not T critical values. 1b). Assuming that your sample estimate is accurate, how large would the sample need to be for the 95% confidence interval to have a maximum error of ±5%? (1 mark) HINT: Error e=5%=0.05 Page 2 of 2 Question 2 (One Sample Hypothesis Test 5 marks) Test the belief that, on average, it takes a student more than 30 minutes to get to university each day, using ?? = 0.05: a. State the null and alternative hypotheses (1 mark) b. Calculate the test statistic (1 mark) HINT: We have a large sample, so we can use the Normal distribution (as T approaches Z as the degrees of freedom increases) c. Calculate the critical value (1 mark) d. Draw a conclusion based on this result (1 mark) e. State your conclusion in real world terms (1 mark) Question 3 (Two Sample Hypothesis Test 3.5 marks) Test to see if there is a difference in the average number of hours studied depending on if you are a chemical engineering student or are a civil engineering student. This data is prepared for you in the Hours Studied worksheet: a. Examine the ratio between variances to see if it appears safe to assume equal variance between the two groups (0.5 mark) b. Perform a two-sample hypothesis test to examine if the average number of hours studied is different between the two student groups (using ?? = 0.05). Follow all the steps of hypothesis testing, including stating your null and alternative hypotheses and drawing a “real-world” conclusion. (1.5 marks) HINT: The Analysis Toolpak can do this for you. c. Are we making any assumptions about the distribution of our data? Are these assumptions valid? If not, how might this impact on your results? (1.5 mark) Responses TimestampWhat's your age?What's your gender?Which of these categories apply to your program?CivilChemicalWould you describe yourself as a morning person, or an evening person?On average, how many hours of study do you do each week?On average, how many minutes does it take for you to get to university from where you live?In general, do you bring lunch to university, or buy it?On a scale from 1 to 10, how excited are you about statistics?On a scale from 1 to 10, how useful do you think statistics will be in your career?What's an engineering project/problem that you think is really cool?If you got to pick the data you wanted to work with for this class, what applications/areas would you be interested in looking at? (Literally anything from "real world" problems through to pop culture stuff, data is data. Safe for work things only though, I don't want to lose my job ._. )If the response dataset for this survey were to be distributed to the class, would you be happy to have your response included? (Your name is not recorded) 9/5/2017 9:36:1220MaleChemical Engineering/ChemistryChemistryNon-CivilMorning Person2030Bring lunch1010Hyperloop ProjectData from current research projects being undertakenYes, feel free to release 9/5/2017 9:37:2620MaleChemical Engineering/ChemistryChemistryNon-CivilEvening Person560Buy lunch79...excel lesson maybeYes, feel free to release 9/5/2017 9:41:4619MaleChemical Engineering/Chemistry, ManagementChemistryNon-CivilMorning Person214588not surePop cultureYes, feel free to release 9/5/2017 9:44:4519FemaleChemical Engineering/Chemistry, ManagementChemistryNon-CivilEvening Person1010Buy lunch58Yes, feel free to release 9/5/2017 9:45:4318MaleCivil/Infrastructure Engineering, ManagementNon-ChemCivilEvening Person580Buy lunch46HyperloopData related to civil engineering (or engineering in general)Yes, feel free to release 9/5/2017 12:03:5720FemaleCivil/Infrastructure EngineeringNon-ChemCivilNeither3540Bring lunch14Designing bridges against earthquake loadsYes, feel free to release 9/5/2017 12:04:3918MaleCivil/Infrastructure EngineeringNon-ChemCivilEvening Person360Buy lunch69Yes, feel free to release 9/5/2017 12:06:1020MaleChemical Engineering/ChemistryChemistryNon-CivilEvening Person260Buy lunch110Yes, feel free to release 9/5/2017 12:06:4419MaleCivil/Infrastructure Engineering, ManagementNon-ChemCivilEvening Person650Bring lunch87metro tunnelsomething related to Game of Thrones Yes, feel free to release 9/5/2017 12:09:3518FemaleCivil/Infrastructure EngineeringNon-ChemCivilEvening Person950Buy lunch65Metro Tunnel ProjectEPL Fantasy League, AFL finals Yes, feel free to release 9/5/2017 12:12:1918MaleCivil/Infrastructure Engineering, ManagementNon-ChemCivilEvening Person560Buy lunch36Mars roverPsychological data (eg placebo effect, data on what makes people do certain things (how sleep affects life for instance), etc.)Yes, feel free to release 9/5/2017 12:13:0619FemaleCivil/Infrastructure EngineeringNon-ChemCivilEvening Person460Bring lunch56Metro tunnelYes, feel free to release 9/5/2017 12:16:5822MaleChemical Engineering/ChemistryChemistryNon-CivilEvening Person550Bring lunch710Energy productionReal world data examplesYes, feel free to release 9/5/2017 12:21:1419MaleChemical Engineering/ChemistryChemistryNon-CivilEvening Person140Buy lunch27Problem solving. Finding faults. Failure assesment. Maximizing efficiencyEngineering applications that would be used in industryYes, feel free to release 9/5/2017 13:00:38Prefer not to sayChemical Engineering/Chemistry, OtherChemistryNon-CivilMorning Person4045Bring lunch56Palm islandsCurrent worth of average salary back in the day to now Yes, feel free to release 9/5/2017 13:09:2819MaleCivil/Infrastructure EngineeringNon-ChemCivilMorning Person620Bring lunch79Tunnels Places to eat Yes, feel free to release 9/5/2017 13:22:5318MaleCivil/Infrastructure EngineeringNon-ChemCivilMorning Person1515Bring lunch79curved sky scrapersYes, feel free to release 9/5/2017 13:28:1121MaleChemical Engineering/ChemistryChemistryNon-CivilEvening Person235Buy lunch110Cold fusionAnything sports related preferably not AFL Yes, feel free to release 9/5/2017 13:38:2525MaleCivil/Infrastructure EngineeringNon-ChemCivilMorning Person2045Bring lunch45StructuralsportsYes, feel free to release 9/5/2017 13:53:2118MaleCivil/Infrastructure EngineeringNon-ChemCivilEvening Person25Buy lunch35Game of ThronesYes, feel free to release 9/5/2017 13:58:2619MaleCivil/Infrastructure EngineeringNon-ChemCivilEvening Person090Bring lunch17Beams and ****Couldn't give a ****Yes, feel free to release 9/5/2017 14:30:3018FemaleChemical Engineering/ChemistryChemistryNon-CivilEvening Person1145Buy lunch57EWB projectTV shows or music industryYes, feel free to release 9/5/2017 15:03:2719MaleCivil/Infrastructure EngineeringNon-ChemCivilEvening Person45Bring lunch54metro rail tunnelYes, feel free to release 9/5/2017 15:03:5122MaleCivil/Infrastructure EngineeringNon-ChemCivilEvening Person1060Buy lunch1010Yes, feel free to release 9/5/2017 15:14:0918MaleCivil/Infrastructure EngineeringNon-ChemCivilNeither50Bring lunch77Development of multi-storey complexsNot fussedYes, feel free to release 9/5/2017 15:39:28FemaleChemical Engineering/ChemistryChemistryNon-CivilEvening Person10Bring lunch66Yes, feel free to release 9/5/2017 15:46:0220MaleChemical Engineering/ChemistryChemistryNon-CivilEvening Person615Buy lunch48Yes, feel free to release 9/5/2017 16:53:56MaleCivil/Infrastructure EngineeringNon-ChemCivilMorning Person401Bring lunch66Analysing the failure data of structures with different characteristics under different conditionsRelated to civil engineeringYes, feel free to release 9/5/2017 17:51:5718FemaleCivil/Infrastructure EngineeringNon-ChemCivilEvening Person1020Bring lunch25the new Metro tunnel expansion international data maybe concerning mortality rates or age expectancy Yes, feel free to release 9/5/2017 20:17:3520FemaleCivil/Infrastructure EngineeringNon-ChemCivilMorning Person3065Bring lunch15Yes, feel free to release 9/5/2017 20:40:2718MaleCivil/Infrastructure EngineeringNon-ChemCivilEvening Person3060Buy lunch89building a bridge or a high rise towerYes, feel free to release 9/5/2017 21:33:2920MaleChemical Engineering/ChemistryChemistryNon-CivilMorning Person2515Buy lunch56unemployed and employed chemical engineering graduates exclusively for international studentYes, feel free to release 9/5/2017 21:34:0819MaleCivil/Infrastructure EngineeringNon-ChemCivilEvening Person750Buy lunch33Designing a structureSomething to do with the housing marketYes, feel free to release 9/5/2017 22:24:2823MaleCivil/Infrastructure EngineeringNon-ChemCivilEvening Person530Buy lunch55Yes, feel free to release 9/6/2017 12:01:1718MaleCivil/Infrastructure EngineeringNon-ChemCivilEvening Person1260Bring lunch87Melbourne Metro Rail TunnelMaterial strength, student data, census data, political dataYes, feel free to release 9/6/2017 12:03:3019MaleCivil/Infrastructure EngineeringNon-ChemCivilMorning Person530Bring lunch77Melbourne MetroanythingYes, feel free to release 9/6/2017 12:17:3819MaleCivil/Infrastructure EngineeringNon-ChemCivilEvening Person2050Bring lunch48Melbourne Metro Rail projectglobal economic data, economic crisis/collapse and growth.Yes, feel free to release 9/6/2017 12:56:3418FemaleCivil/Infrastructure EngineeringNon-ChemCivilEvening Person150Buy lunch15Yes, feel free to release 9/6/2017 14:10:37MaleChemical Engineering/ChemistryChemistryNon-CivilMorning Person1545Buy lunch52Yes, feel free to release 9/6/2017 16:31:3922MaleFood Technology/NutritionNon-ChemNon-CivilMorning Person230Buy lunch65F1 carsStatistics on sports. E.G Number of times a player takes a shot on goal in the full 90 minutes of a game for soccer. Yes, feel free to release 9/6/2017 17:07:4719MaleCivil/Infrastructure EngineeringNon-ChemCivilEvening Person1010Buy lunch79Flood water controlStudy about homeless people on the streets on MelbourneYes, feel free to release 9/6/2017 19:02:1623MaleCivil/Infrastructure EngineeringNon-ChemCivilEvening Person1445Buy lunch47Tethering deep sea drilling structures I have no idea, avocado consumption and the housing market. Yes, feel free to release 9/6/2017 20:18:5618MaleCivil/Infrastructure EngineeringNon-ChemCivilMorning Person740Buy lunch46Yes, feel free to release 9/6/2017 20:38:5719MaleCivil/Infrastructure EngineeringNon-ChemCivilEvening Person310Bring lunch810to build wonderful by my handwhich jobs do classmates prefer tp in the futureYes, feel free to release 9/6/2017 22:55:44MaleCivil/Infrastructure Engineering, ManagementNon-ChemCivilEvening Person1070Buy lunch79Yes, feel free to release 9/7/2017 8:26:5020FemaleChemical Engineering/ChemistryChemistryNon-CivilEvening Person22150Bring lunch67Pharmaceutical inventions are my thingRick and morty and the number of universes to ricks and mortys?Yes, feel free to release 9/7/2017 15:36:2223MaleChemical Engineering/ChemistryChemistryNon-CivilEvening Person1050Bring lunch410Engineers without bordersAFLYes, feel free to release 9/7/2017 17:55:1820MaleChemical Engineering/Chemistry, ManagementChemistryNon-CivilMorning Person1045Bring lunch77sportsYes, feel free to release 9/7/2017 23:22:2418FemaleCivil/Infrastructure EngineeringNon-ChemCivilNeither525Bring lunch45Still working on that I don't know whateverrrrYes, feel free to release 9/9/2017 14:44:5027MaleCivil/Infrastructure EngineeringNon-ChemCivilEvening Person3045Bring lunch58Rio–Antirrio bridgeAreas related to engineering and our field (i.e. civil), but anything interesting really.Yes, feel free to release 9/10/2017 19:59:5122MaleChemical Engineering/ChemistryChemistryNon-CivilEvening Person1030Buy lunch87Sustainable EnergyNo at all.Yes, feel free to release 9/10/2017 20:13:00MaleCivil/Infrastructure EngineeringNon-ChemCivilNeither360Buy lunch77Public Transport construction sportYes, feel free to release 9/10/2017 21:46:1022MaleChemical Engineering/ChemistryChemistryNon-CivilEvening Person2530Buy lunch89improving efficiency of enginesfood macro nutrients Yes, feel free to release 9/11/2017 19:59:1520MaleChemical Engineering/ChemistryChemistryNon-CivilEvening Person3240Buy lunch48provide energy from fusion music genre data Yes, feel free to release 9/11/2017 23:51:5919MaleChemical Engineering/ChemistryChemistryNon-CivilMorning Person410Bring lunch7710000000m high buildingWarYes, feel free to release 9/13/2017 4:32:5219FemaleCivil/Infrastructure EngineeringNon-ChemCivilNeither270Buy lunch55puppiesYes, feel free to release 9/13/2017 23:37:3820MaleChemical Engineering/Chemistry, ManagementChemistryNon-CivilNeither52Bring lunch1010building a space reactorpeople's pop-culture interests Yes, feel free to release 9/25/2017 12:08:2022MaleChemical Engineering/ChemistryChemistryNon-CivilEvening Person35Buy lunch66Fluid dynamicsGive us the freakonomics stuffYes, feel free to release 9/5/2017 12:47:2520MaleCivil/Infrastructure EngineeringNon-ChemCivilEvening Person25Buy lunch107 Hours Studied CivilChemistryCivil Chemistry10 Chemistry21 Chemistry22 Chemistry43 Chemistry53 Chemistry53 Chemistry54 Chemistry65 Chemistry105 Chemistry105 Chemistry105 Chemistry105 Chemistry116 Chemistry156 Chemistry207 Chemistry217 Chemistry229 Chemistry2510 Chemistry2510 Chemistry3210 Chemistry4010 12 14 15 20 20 30 30 30 35 40