Please answer 3.1.1 3.1.2 and 3.1.3 Q.3.1Determine the % marks that the students obtained for each of the tests, giventhat:Q.3.1.1The Maths test was out of 200 marks. Determine this by entering anappropriate formula in cells C2 to C9.Q.3.1.2The Science test was out of 60 marks. Determine this by entering anappropriate formula in cells E2 to E9.Q.3.1.3The English test was out of 80 marks. Determine this by entering anappropriate formula in cells G2 to G9. Question 3We have been given the marks obtained by a group of eight students on three tests. These areindicated in the figure below. In the third worksheet of your Excel answer book provided, createthe following:AEGH1Student Maths % Mark Science % Mark English % Mark Student's Average Mark (%)Vusi1864572Beth18448764 Tebogo1563968Heather1765772Adel17436727Bianca14242608Candice1403664Dylan138335210Average Maths Mark (%) =Average Science Mark (%) =Average English Mark (%) =Average Overall Mark (%) =11121314

Name: Please answer 3.1.1 3.1.2 and 3.1.3 Q.3.1Determine the % marks that th
Uploaded: 2024-03-05T11:53:49.000Z
Channel: Bartleby
Description: Please answer 3.1.1 3.1.2 and 3.1.3 Q.3.1Determine the % marks that the students obtained for each of the tests, giventhat:Q.3.1.1The Maths test was out of 200 marks. Determine this by entering anappropriate formula in cells C2 to C9.Q.3.1.2The Scien

Explanation: 3.1.1). In cell C2, enter the formula =B2*100/200 Click enter Put cursor on bottom…

Math

Statistics

Q.3.1 Determine the % marks that the students obtained for each of the tests, given that: Q.3.1.1 The Maths test was out of 200 marks. Determine this by entering an appropriate formula in cells C2 to C9. Q.3.1.2 The Science test was out of 60 marks. Determine this by entering an appropriate formula in cells E2 to E9. Q.3.1.3 The English test was out of 80 marks. Determine this by entering an appropriate formula in cells G2 to G9.

Q.3.1 Determine the % marks that the students obtained for each of the tests, given that: Q.3.1.1 The Maths test was out of 200 marks. Determine this by entering an appropriate formula in cells C2 to C9. Q.3.1.2 The Science test was out of 60 marks. Determine this by entering an appropriate formula in cells E2 to E9. Q.3.1.3 The English test was out of 80 marks. Determine this by entering an appropriate formula in cells G2 to G9.

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

The U.S. Census Bureau collects data on household size and publishes the information in Current Population Reports. What kind of data is the number of people in your household?
A sports psychologist wants to compare the running time for athletes vs non-athletes while running 1 mile. He collects data from 226 non-athletes and 166 athletes and analyzes it using SPSS.
According to a report published by the center for Disease Control (CDC) in 2011, approximately one in two people with asthma had an asthma attack in2008.
Use z scores to compare the given values. Based on sample data, newborn males have weights with a mean of 3224.6 g and a standard deviation of 739.9 g. Newborn females have weights with a mean of 3027.5 g and a standard deviation of 473.6 g. Who has the weight that is more extreme relative to the group from which they came: a male who weighs 1700 g or a female who weighs 1700 g? Since the z score for the male is z= and the z score for the female is z= the has the weight that is more extreme. (Round to two decimal places.)