Q5) Refer to the data given below and answer the following questions usingappropriate function/formula:cagaB CDGHK1NameAttendance DatesQuiz 1Quiz 2Quiz 3Quiz 4Quiz 58/10/2020 8/10/2020 8/10/2020 8/10/2020 5/11/20203AliPP5610AhmedPAP745ZiaA7644SadafAP6497HarisA43Page 1 of 2Note: Blank in the attendance dates show that student was unregistered.Use cell references in all the functions.a) Calculate the number of classes in which Haris was unregistered.b) Evaluate by formula, the average marks obtalned by Zla In the quizzes.c) Calculate the total number of classes in which Ahmed was registered aswell as in which he was unregistered.d) Display the minimum marks obtained by any student in any of thequizzes.ITe) Calculate the average of best four quizzes of Ali.f) Evaluate the 2nd highest marks obtained by any student in any of thequizzes.9) Compute the number of students in the class.h) Count the number of cells with a value greater than or equal to 4 and lessthan or equal to 9.aleP.

Hey, since there are multiple subparts posted, we will answer first three subparts. If you want any…

Answered: Q5) Refer to the data given below and…

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 following table was generated from the sample data of 10 junior high students regarding the average number of hours they are unsupervised per night, the average number of hours they play video games per night, and their final grades in their math class. The dependent variable is the final grade, the first independent variable (x1) is the number of hours unsupervised each night, and the second independent variable (x2) is the number of hours of video games each night. Coefficients Standard Error t-Stat p-value Intercept 62.711817 4.607133 13.611896 0.000010 Hours Unsupervised 0.635048 0.915495 0.693666 0.513836 Hours Playing Video Games 7.528738 1.296727 5.805955 0.001145 Copy Data Step 1 of 2: Write the multiple regression equation for the computer output given. Round your answers to three decimal places. Answer 田 Tables 国 Keypad How to enter your answer (opens in new window) Keyboard Shortcuts X +
Johnson Filtration, Inc., provides maintenance service for water-filtration systems throughout southern Florida. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Time bo + b₁ Months + b₂ Type + b3 Person Round your answers to three decimal places. bo b₁ b₂ b3 Repair Time in Hours 2.8 3.0 4.7 1.9 2.9 4.8 4.2 4.9 4.3 4.4 0000 Months Since Last Service 2 6 8 3 a. Develop the estimated regression equation to predict the repair time given the number of months since the last maintenance service, the type of repair, and the repairperson who performed the service. Assume that ₂ = 1 if the type of repair is electrical and 3 = 1 if Dave Newton performed the service. Enter negative value as negative number. 2 7 9 8 4 6 Type of Repair Electrical Mechanical Electrical Mechanical…
Next question Use the following cell phone airport data speeds (Mbps) from a particular network. Find Q1 0.1 0.2 0.3 0.3 0.3 0.4 0.6 0.6 0.6 0.7 O 0.8 0.8 0.8 0.8 0.9 0.9 1.1 1.2 1.2 1.3 1.8 1.8 2.1 2.1 2.5 2.6 2.7 2.7 3.9 3.9 4.2 4.9 57 6.4 7.3 7.5 7.8 8.2 8.7 9.4 10.1 10.4 11.5 12.4 13.1 13.4 14.7 14.8 14 9 27.7 Q1 = Mbps (Type an integer or a decimal. Do not round.)
The data indicate the number of wins and the number of goals scored for teams in the National Hockey League after the first month of the season. No. of wins, x B 5 6 9 10 0.885 Part: 0/3 9 Part 1 of 3 5 3 No. of goals, y 10 16 20 23 28 21 11 12 No. of wins, x 11 7 13 5 7 No. of goals, y 20 11 10 20 29 12 17 (a) Find the equation of regression line and draw the line on the scatter plot, but only if r is significant. Round the slope and y-intercept to four decimal places, if necessary. r (Choose one) significant at the 5% level. X
Pls help to solve this homwork
This dataset of size n - 51 is for the 50 states and the District of Columbia in the United States. The variables are - year 2002 birth rate per 1000 females 15 to 17 years old and z- poverty rate (the percent of the state's population living in households with in- comes below the federally defined poverty level) i- 13.1 - 22.3 R- 51, Su - E(-2) - 914.7 S, - E( -2)( - 6) - 1, 256.2 Su - E(m - M) - 3, 249 SSE - E(w - - 1, 509.6 1. Find A. A and r. 2. Write the fitted linear regression model for ý, in terms of z, A, and A- For A and , use the values you obtained in problem 1. 3. Interpret the slope of the least squares line based on the context. 4. Find SST, SE and SSR. 5. Find R* and . 6. Complete a chart for ANOVA df MS pvalue Source Regression Error Total 7. Complete a chart for Parameter Estimates. t-value pvalue Parameter Intercept Slope Estimate S.e. 8. What is the residual e, for the observation (.) - (20.1,31.5)? 9. What is the conclusion for the test Ha : -0 vs Ho : +0 with a -…

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS