Scribd Logo
Upload

Welcome to Scribd!

  • 31 views

    Midterm AE108 Practical 10-7-22

    Uploaded by

    cheesekuh

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Midterm AE108 Practical 10-7-22

    Uploaded by

    cheesekuh
    31 views2 pages

    Original Title

    Midterm AE108 practical 10-7-22

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    31 views2 pages

    Midterm AE108 Practical 10-7-22

    Uploaded by

    cheesekuh

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    Republic of the Philippines

    CAMARINES NORTE STATE COLLEGE


    F. Pimentel Avenue, Brgy. 2, Daet, Camarines Norte – 4600, Philippines

    College of Business and Public Administration


    Summ
    AE 108 – Statistical Analysis with Software Application
    1st Semester, AY 2022 – 2023
    Midterm Examination

    Name: Score:
    Course, Year Level & Block Section: Date:

    PART 2

    A. At a large university, students are classified according to the following scheme:

    Housing Number of Students


    Campus Dormitory 2100
    Fraternity House 720
    Private Residence 3400

    If one uses proportional allocation to select a stratified random sampling of size n = 500, how
    large a sample must be taken from each stratum? (5 pts.)

    B. The following is a list of Marco’s Pizza stores in Lucas City. Also noted is whether the store is
    corporate-owned© or manager-owned (M). A sample of 10 location is to be selected and inspected
    for customer convenience, safety, cleanliness and other features.

    1. A sample is to consist of every seventh location. The number 03 is the starting point. Give 2
    locations to be included in the sample? (2 pts.)

    2. a. What sampling techniques was used? (1 pt.)


    b. Why? (2 pts.)

    3. If the sample size is proportional as to the type of store, how many of each type should be
    included? (5 pts.)

    C. Use the MS document named Police Profile.xlsx.to answer the following questions. Submit the MS
    Excel file used in finding the solution/answer.

    CNSC-OP-VPA-01F11 Page 1 of 2
    Revision: 0
    Republic of the Philippines
    CAMARINES NORTE STATE COLLEGE
    F. Pimentel Avenue, Brgy. 2, Daet, Camarines Norte – 4600, Philippines

    College of Business and Public Administration


    Summ
    AE 108 – Statistical Analysis with Software Application
    1st Semester, AY 2022 – 2023
    Midterm Examination

    1. Make a Pivot Table to summarize the data showing the demographic profiles in rows and
    the number of respondents in columns. (5 pts.)
    2. Make a Pie chart for the sex profile of the police officers (5 pts)
    3. Find the average, standard deviation, mode, and median of the performance of police
    officers (4 pts.)
    4. Is there a significant difference on the performance of male and female police officers?

    Prepared by:

    Maria Elena A. Bidar


    Faculty

    CNSC-OP-VPA-01F11 Page 2 of 2
    Revision: 0

    You might also like