Question
Directions: Submit your results/answers electronically in a Microsoft word file (unless otherwise specified) to the google classroom assigned to the subject and to the classwork
Directions: Submit your results/answers electronically in a Microsoft word file (unless otherwise specified) to the google classroom assigned to the subject and to the classwork where this activity is posted with the filename: ACTIVITY2_GRADUATE_STATISTICS_FAMILY NAME. Those without internet connectivity may submit in hardcopy to the Office of the Dean addressed to Dr. Hafalla at room HB202, Centennial Building, UB. Do not forget to indicate your name, schedule and date in the subject heading of this paper. At the end of the semester, all submitted requirements and copies of the activities must be printed and compiled by you for submission to the Graduate School Office. The deadline of this activity is set by the professor. Future activities will be posted via the google classroom.
I. Individual Activity 1. Given a standard normal distribution, find the area under the curve which lies (a) to the left of z=-1.96, (b) to the right of z=1.64, (c) between z=- 1.96 and z=1.64; (d) to the right of z=-1.96.
2. Encode the following data in the SPSS data editor or any other statistics software or web-based programs (ie. EXCEL). Properly label your data. Table 1. Electrical Consumption in Fiscal Year 2020 Month Location/Plant Electrical Cost (Php)
Quezon City 84,126.88January Manila 66,812.98 Quezon City 91,112.15February Manila 78,340.96 Quezon City 101,212.69March Manila 88,627.55 Quezon City 123,520.65April Manila 92,812.15 Quezon City 145,800.65May Manila 105,900.83 Quezon City 120,812.55June Manila 95,612.89 Quezon City 99,220.35July Manila 84,612.94 Quezon City 105,689.65August Manila 90,345.76 Quezon City 101,995.68September Manila 88, 612.89 Quezon City 104,660.84October Manila 91,312.45 Quezon City 95,781.92November Manila 78,612.45 Quezon City 90,320.89December Manila 71,314.78
Page 2 of 2 GRADUATE SCHOOL General Luna Road, Baguio City Philippines 2600 Graph the data using two line graphs where the lines represent those of Quezon City plant's electrical bills and the other line for the Manila plant. Label properly your graph (x-axis represents the months, y-axis is the monthly electrical cost). Interpret the graph. 3. Using SPSS or other software or manual computation, test the hypothesis that the Manila plant electrical bill consumption is on average at most Php 95,000.00. Write your Ho and Ha (in symbols or in words). Post all relevant outputs from the software or from your computation. Interpret the p-value (if manual computation, this is not needed). Use APA format in interpreting the results. 4. Compare the electrical costs between the two plants. Test the hypothesis that the Quezon City plant consumes more electricity than the Manila plant by at least Php 12,000.00. State your Ho and Ha. Post all relevant outputs below. Interpret the p-value and the results (if manual computation, p-value is not needed). ANSWERS BELOW THIS LINE:
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started