Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. 3 Construct the following table in a spreadsheet to answer the questions given below it. Details of Students SAT score, Grade Score and Study

image text in transcribed
2. 3 Construct the following table in a spreadsheet to answer the questions given below it. Details of Students SAT score, Grade Score and Study Hours per week Self- SI. Study No. Name Gender Student Status Major SAT Grade Height Country Age hours Score Score per week 1 Abdullah Male Graduate Economics UAE 33 1716 78 68 24 2 Muneer Male Graduate Economics UAE 37 1701 65 71 26 Ali Male Graduate Economics SA 25 1786 69 67 20 Sara Female Undergraduate Math Oman 18 91 62 14 5 Fatima Female Graduate Math Bahrain 33 2041 71 66 24 Taheer Male Undergraduate Economics Qatar 18 1787 82 67 14 7 Mizzon Female Graduate Math SA 38 1513 79 59 20 8 Ayaz Male Graduate Politics Oman 30 1637 79 63 18 9 Ahmed Male Graduate Politics Bahrain 30 1512 70 75 22 10 Sharifa Female Undergraduate Math Oman 19 1494 75 60 16 11 Zeena Female Graduate Politics UAE 31 2248 95 59 25 12 Salim Male Graduate Politics Oman 33 1923 95 28 13 Mallak Female Undergraduate Politics Qatar 19 1919 88 64 16 4 1813 on 63 A) What is the average height of Female Students? (1 Marks) B) C) How many students scores less than 75 grade score? (1 Marks) Calculate the third score from the lowest SAT score. Also, state the name of the student and country as well. (1 Marks) D) What is the Mode age of the students? (1 Marks) E) Construct a line chart for Grade Score and height of the every student. (2 Marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Basics

Authors: 3G E-Learning

1st Edition

1984624261, 978-1984624260

More Books

Students also viewed these Accounting questions