Score GPA Hours Absences Gender78 3.15 3.0 4 Female75 2.71 4.0 1 Female79 3.57 3.5 2 Male85 3.26 6.5 0 Female85 3.75 2.0 0 Female84 3.20 4.5 3 Female85 3.16 5.0 3 Male80 3.35 1.5 0 Female74 2.75 3.5 6 Male81 3.04 6.5 1 Male76 2.53 3.0 0 Female85 2.92 6.0 1 Male A business statistics professor would like to develop a regression model to predict the final exam scores for studentsbased on their current GPAS, the number of hours they studied for the exam, the number of times they were absentduring the semester, and their genders. The data for these variables are given in the accompanying table. Completeparts a through e below.Click the icon to view the data table.a. Using Excel, construct a regression model using all of the independent variables. Create the dummy variable Gen,which equals 1 for a male and 0 for a female student (this assignment is arbitrary).Complete the regression equation for the model below, where y = Score, x₁ = GPA, x₂ = Hours, x3 = Absences, andX4 = Gen.ŷ=+(x₁+x₂ + (x3 +×4(Round to two decimal places as needed.)

Here the dependent variable (y) is the Score for students.There are four independent variables:x1 =…

a. Using Excel, construct a regression model using all of the independent variables. Create the dummy variable Gen, which equals 1 for a male and 0 for a female student (this assignment is arbitrary). Complete the regression equation for the model below, where y=Score, x₁ =GPA, X₂ = Hours, x3 = Absences, and X4 = Gen.

a. Using Excel, construct a regression model using all of the independent variables. Create the dummy variable Gen, which equals 1 for a male and 0 for a female student (this assignment is arbitrary). Complete the regression equation for the model below, where y=Score, x₁ =GPA, X₂ = Hours, x3 = Absences, and X4 = Gen.

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 table below gives the percent of U.S. seniors (aged 65+ years) who used the internet in selected years. Year 2012 2014 2016 2018 2019 % of U.S. seniors using internet 54 57 64 66 73 Use a line of best-fit to predict the percent of U.S. seniors who will use the internet in the year 2022. A. 74 % B.76 % C.77 % D.79 % E.81 %
What percent of females don't have heart disease? Sex (1=Male 2=Female) 1 2 Total Ever told heart disease (1=Yes 2=No) 1 Count 73 96 169 % within Ever told heart 43.2% 56.8% 100.0% disease (1=Yes 2=No) % within Sex (1=Male 10.2% 9.3% 9.7% 2=Female) % of Total 4.2% 5.5% 9.7% 2 Count 640 941 1581 % within Ever told heart 40.5% 59.5% 100.0% disease (1=Yes 2=No) % within Sex (1=Male 2=Female) 89.8% 90.7% 90.3% % of Total 36.6% 53.8% 90.3% Total Count 713 1037 1750 % within Ever told heart disease (1=Yes 2=No) 40.7% 59.3% 100.0% % within Sex (1=Male 100.0% 100.0% 100.0% 2=Female) % of Total 40.7% 59.3% 100.0% 59.5% 89.8% 53.8% 90.7%
Statistics students in Oxnard College sampled 11 textbooks in the Condor bookstore and recorded the number of pages in each textbook and its cost. The data are shown below: Number of Pages (x) Cost(y) 836 75.88 695 62.6 565 40.2 990 85.2 231 27.48 383 33.64 370 25.6 638 55.04 526 42.08 752 63.16 845 78.6 A student calculates a linear model using technology (Statistics Calculator or Computer) (Please show your answers to two decimal places) %3D Use the model to estimate the cost when number of pages is 833. Cost = $ (Use the linear model with yor rounded coefficients and then round your answer to 2 %3D decimal places.)
Frequency 344.7 389.1 394.3 411.8 412.1 431.9 433.5 445 447.4 452.3 465.4 466 469.2 469.2 469.2 469.8 470.6 471.7 471.8 474.9 483 483.1 485 490.4 494.8 495.8 496.8 496.8 500 506.8 512.5 516.6 520.1 520.4 524.8 534.8 545.3 547.4 558.1 556.4 558.1 558.1 580.6 564.4 572.4 577.4 585 586.2 587.8 588.2 593.8 606.1 607.8 611.4 = 18 16 14 12 10 8 6 4 2 300 350 400 450 500 Find the first quartile for this data set. Q₁ length (cm) = 550 600 650 Find the third quartile for this data set. Q3² = Find the interquartile range for this data set. IQR = = Find the lower fence separating outliers from usual values. Fence Low Find the upper fence separating outliers from usual values. Fence high
observe the patterns of the prices of oil then compute for the percentage of increase/decrease yearly Event Numbers Patterns Prices of oil 2016 2,195.24 2017 2576.07 2018 3307.81 2019 2889.96 2020 2012.17 2021 3337.23
Online Trailer Views (millions) Opening Weekend Box Office Gross ($millions) Online Trailer Views (millions) Opening Weekend Box Office Gross ($millions) 58.485 31.963 3.169 1.611 10.539 2.563 32.824 63.843 7.290 6.615 4.267 13.376 11.117 20.214 42.382 86.251 83.747 102.996 4.989 4.690 32.036 60.081 6.630 33.377 21.858 19.098 0.942 3.705 6.362 9.752 2.258 1.513 1.984 9.872 11.327 18.470 47.499 35.661 8.966 12.202 5.433 21.575 15.177 4.357 27.396 18.002 13.714 30.436 2.141 2.859 31.231 53.003 57.337 150.198 52.612 46.607 7.918 11.225 16.235 13.003 8.372 6.775 6.884 3.776 9.117 0.427 11.698 18.223 1.888 5.706 2.827 3.471 2.883 3.998 23.075…
Statistics students in Oxnard College sampled 11 textbooks in the Condor bookstore and recorded the number of pages in each textbook and its cost. The data are shown below: Number of Pages (xx) Cost(yy) 936 129.68 971 124.23 458 62.54 487 73.31 647 97.11 648 98.24 869 115.97 774 113.62 426 61.38 671 91.23 658 83.54 A student calculates a linear model using technology (Statistics Calculator or Computer)ˆyy^ = xx + . (Please show your answers to two decimal places)Use the model to estimate the cost when number of pages is 583.Cost = $ (Use the linear model with yor rounded coefficients and then round your answer to 2 decimal places.)
Sales of a particular product for the years 2017 through 2020 have been 390, 455, 432 and 487 respectively. What sales would you predict for 2021 using a weighted moving average with weights of 0.45 for the immediate preceding year and 0.3, 0.15 and 0.1 for the three years before that?
S An employee at Coconino Community College (CCC) is evaluated based on goal setting and accomplishments toward the goals, job effectiveness, competencies, and CCC core values. The categories, ratings, and weights for a particular employee are shown in this table. Weight % 2 Category Competency 1 Competency 2 Competency 3 Competency 4 Competency 5 Goal 1 Goal 2 Job Effectiveness Core Values Rating 3 2 4 2 4 4 4 3 2 433 3 20 2282 22 20 23 Compute a weighted average score for this employee. Round your answers to two decimal places. Average score for this employee:
1.37 Fur seals on St. Paul Island. Every year, hundreds of thou- sands of northern fur seals return to their haul-outs in the Pribilof Islands in Alaska to breed, give birth, and teach their pups to swim, hunt, and survive in the Bering Sea. U.S. commercial fur sealing operations continued on St. Paul until 1984, but despite a reduction in harvest, the population of fur seals has continued to decline. Possible reasons include climate shifts in the North Pacific, chang- es in the availability of prey, and new or increased interac- tion with commercial fisheries that increase mortality. Here are data on the estimated number of fur seal pups born on St. Paul Island (in thousands) from 1979 to 2014, where a dash indicates a year in which no data were collected:28 FURSEALS Arco Images GmbH/Alamy
Give the statistical meaning of the relationship between the spending hours on using mobile andreading books per day.