6301-HW2-S24

xlsx

School

University of Texas, Dallas *

*We aren’t endorsed by this school

Course

6301

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

46

Uploaded by GeneralFoxMaster1044

Report
H If you have any question DO NOT change the structure of Follow the su Name the f Problem Set 1 Set 2 Set 3 Set 4 Total You must use Excel functions when Do not round-off your ans DO NOT change the structure of the shee Before uploading, double-check that you are uploading the submission is FINAL. NO e-m 5-point (non-refundable) penalty for missing these two steps.
HOMEWORK 2 ::: 30 Points INSTRUCTIONS ns regarding your HW grade, please contact the TA f the sheets. That is, do not add or delete columns / rows. ubmission guidelines (see eLearning). file as: LastName_FirstName_HW2 Last Name First Name NetID Do not make any changes here Points Earned Comments 12 8 4 6 30 0 n available. The work must be done within the cells themselves. swers , but format the cells to show 4 decimal places. ets. That means do not add or delete columns or ro correct file. Do not upload while the file is still open. Once uploade mailed or late submissions will be accepted.
ows. D O N OT ch an ge th e str uc tur e of th e sh ee ts. Th at m ea ns do no t ad ed, your
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ad d or del et e col u m ns or ro ws . `
Name : 12 0 Miles Price 24.2 15.4 38.8 14.3 45.6 14.5 28.7 15.6 38.2 14.7 36.7 14.4 32.5 15.2 39.1 14.1 45.3 14.2 34.4 14.8 38.4 15.1 32.2 15.0 26.6 15.7 33.5 14.6 41.8 14.5 36.7 14.8 37.5 14.8 25.6 15.7 40.1 15.0 31.0 14.9 42.2 14.4 37.4 14.2 The table below lists the prices (in thousands) of use (regression line) using Excel. Run Excel's Regression the predicted price. Then fill the remaining columns. numbers calculated by Excel's Regression program. C Predicted Price Residual (Error) DO NOT change the structure of the sh keep out of this area
34.4 15.4 30.6 15.6 42.5 14.6 38.4 14.3 40.5 14.3 26.0 15.5 46.3 13.9 34.8 14.5 2.0 1. SSE 2.0 2. SST 2.0 3. SSR 1.0 4. R-Squared 2.0 5. Std Err of estimate 6. Scatter Plot with Trendline 3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
7. Residual graph 3.0 3 Right F23 Regression Output
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Video on R2 ed cars sold and the corresponding miles (in thousands). Create a Scatter diagram and the trendline program (to be displayed starting cell H91) and plot the residual graph. Use the Regression equation to get . Then use this data to calculate the SSE, SST, etc. . If done correctly, these should match the corresponding Class discussion / slides will be very useful in working on this problem. Residual- squared Average Price (Actual - Average) (Actual- Average) Squared (Predicted - Average) (Predicted - Average) Squared heets. That means do not add or delete columns o
SSE : Sum of Squared Errors SST: Sum of Squared Total SSR: Sum of Squared due to Regression R-Squared = SSR / SST = Explained / Total Standard Error = Sqrt(SSE/(n-k-1)) For the graphs below, add PROPER graph titles and also x and y-axis labels!
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
or rows. D O N OT ch an ge th e str uc tur e of th e sh ee ts. Th at
at m ea ns do no t ad d or del et e col u m ns or ro ws . `
D O N OT ch an ge th e str uc tur e of th e sh ee ts. Th at
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
at m ea ns do no t ad d or del et e col u m ns or ro ws . `
Name : 8 0 School Boston College Brandeis University Brown University California Institute of Technology Carnegie Mellon University Case Western Reserve University College of William and Mary Columbia University Cornell University Dartmouth College Duke University Emory University Georgetown University Harvard University John Hopkins University Lehigh University Massachusetts Inst. of Technology New York University Northwestern University Pennsylvania State University Princeton University Rice University It is not uncommon to see that alumn important role in them deciding how m the Alumni Giving rate (percentage of regression model to determine the re DO NOT change the structure of the she keep out of this area
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Stanford University Tufts University Tulane University U. of California-Berleley U. of California-Davis U. of California-Irvine U. of California-Los Angeles U. of California-San Diego U. of California-Santa Barbara U. of Chicago U. of Florida U. of Illinois-Urbana Champaign U. of Michigan-Ann Arbor U. of North Carolina-Chapel Hill U. of Notre Dame U. of Pennsylvania U. of Rochester U. of Southern California U. of Texas-Austin U. of Virginia U. of Washington U. of Wisconsin-Madison Vanderbuilt University Wake Forest University Washington University - St. Louis Yale University 1. Do you think this model is good? T 1.0 2. What proportion of the variation in 1.0
3. Suggest 2 variables (reasons) not in 0.5 0.5 3. The coefficient for student / faculty 2.0 2.0 1.0 F23 Regression Output 4. Carnegie-Mellon (my school) has a ratio of 10. What percentage of the al 5. Find the alumni giving rate for Carn in Q4. What is the residual (error)?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
State MA 85 39 13 25% MA 79 68 8 33% RI 93 60 8 40% CA 85 65 3 46% PA 75 67 10 28% OH 72 52 8 31% VA 89 45 12 27% NY 90 69 7 31% NY 91 72 13 35% NH 94 61 10 53% NC 92 68 8 45% GA 84 65 7 37% DC 91 54 10 29% MA 97 73 8 46% MD 89 64 9 27% PA 81 55 11 40% MA 92 65 6 44% NY 72 63 13 13% IL 90 66 8 30% PA 80 32 19 21% NJ 95 68 5 67% TX 92 62 8 40% ni often give back to their schools. The question is, what factors influence their gratitude and goodwill and play an much to contribute? A sample of some top universities has been analyzed to determine if there is a relationship b f alumni who give) and factors like Graduation rate (percentage), % of class Under 20, and Student / Faculty ratio. elationship. Send the output to Cell H90 . Answer the following questions based on the Excel table. Graduation Rate % of Classes Under 20 Student / Faculty Ratio Alumni Giving Rate eets. That means do not add or delete columns or r
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
CA 92 69 7 34% MA 87 67 9 29% LA 72 56 12 17% CA 83 58 17 18% CA 74 32 19 7% CA 74 42 20 9% CA 78 41 18 13% CA 80 48 19 8% CA 70 45 20 12% IL 84 65 4 36% FL 67 31 23 19% IL 77 29 15 23% MI 83 51 15 13% NC 82 40 16 26% IN 94 53 13 49% PA 90 65 7 41% NY 76 63 10 23% CA 70 53 13 22% TX 66 39 21 13% VA 92 44 13 28% WA 70 37 12 12% WI 73 37 13 13% TN 82 68 9 31% NC 82 59 11 38% MO 86 73 7 33% CT 94 77 7 50% That is, do you see an evidence of relationship? Pick the right option. n Alumni giving is explained by the three variables?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
n the table that can also be affecting the alumni giving rate. y ratio is negative in Excel output. Give a reason as to why this is the case. a graduation rate of 75, has 67% of the class under 20, and has a student / faculty lumni will give money to university endowment as predicted by this model? negie-Mellon from the table. Compare this to your results
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
n between Run a rows. D O N OT ch an ge th e str uc tur e of th e sh ee ts. Th at m ea
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ea ns do no t ad d or del et e col u m ns or ro ws . `
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
D O N OT ch an ge th e str uc tur e of th e sh ee ts. Th at m ea ns do
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
do no t ad d or del et e col u m ns or ro ws . `
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Name : 4 0 Year Month Gasoline Price 1999 1 0.972 1999 2 0.955 1999 3 0.991 1999 4 1.177 1999 5 1.178 1999 6 1.148 1999 7 1.189 1999 8 1.255 1999 9 1.28 1999 10 1.274 1999 11 1.264 1999 12 1.298 2000 1 1.301 2000 2 1.369 2000 3 1.541 2000 4 1.506 2000 5 1.498 2000 6 1.617 2000 7 1.593 2000 8 1.51 2000 9 1.582 2000 10 1.559 2000 11 1.555 When the price of gasoline at the pum we listed on the right the average pric 2001. The source of this data is U.S. D DO NOT change the structure of the sh keep out of this area
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2000 12 1.489 2001 1 1.472 2001 2 1.484 2001 3 1.447 2001 4 1.564 2001 5 1.729 2001 6 1.64 2001 7 1.482 2001 8 1.427 2001 9 1.531 2001 10 1.362 2001 11 1.263 2001 12 1.131 0.75 1. What is the the correlation coefficie 0.75 0.75 1.00 4. Compute the gasoline price for a gi 0.75 F23 Regression Output 2. What is the Slope b 1 of the regress 3. . What is the Intercept b 0 of the reg 5. Comment on the relationship betw Weak?).
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Crude Price Let 8.57 X = Price of a barrel of crude oil 8.6 Y = Price of a gallon of unleaded regular gasoline 10.76 12.82 13.92 14.39 16.12 17.58 20.03 19.71 21.35 22.55 23.53 25.48 26.19 23.2 25.58 27.62 26.81 27.91 29.72 29.65 30.36 mp increases, oil companies often claim that the increase is caused by an increase in the price of crude oil. T ce of a gallon of unleaded regular (U.S. average) and the domestic price of a barrel of crude oil for every mo Department of Energy. All prices are in dollars. Do a regression analysis and send the Regression output to Ce heets. That means do not add or delete columns
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
24.46 24.64 25.27 22.98 23.39 24.06 23.43 22.82 23.08 22.37 18.73 16.4 15.54 ent between X and Y iven crude price of $20.45. sion line gression line ween X and Y (is it strong?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
To examine this claim, onth from 1999 to ell H58. s or rows. D O N OT ch an ge th e str uc tur e of th e sh ee ts. Th at m ea ns do
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
do no t ad d or del et e col u m ns or ro ws . `
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
D O N OT ch an ge th e str uc tur e of th e sh ee ts. Th at m ea ns do no t ad
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ad d or del et e col u m ns or ro ws . `
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Name : 6 0 Output Data Employee Output (O) raining hours(T 1 58.8 24 2 58.7 25 3 58.2 25 4 57 25 5 56.5 25 6 55.2 27 7 54.7 30 8 54.5 30 9 52.8 30 10 51.1 31 11 44.8 32 12 44 33 13 59.4 39 14 59.8 41 15 61.7 43 16 62.5 44 17 62.6 45 18 64.6 60 19 64.9 57 20 65.3 56 21 65.7 56 You are trying to find a relationship be current annual salary. You have collec impact of other variables on this Outp employees? DO NOT change the structure of the she keep out of this area
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
22 66.1 49 23 68.2 48 24 71.8 48 25 71.7 46 26 71.3 46 27 70.1 60 28 69.9 63 29 69.8 63 30 69.6 63 31 68.8 64 32 68.5 68 33 72.6 72 34 73.9 75 35 75.3 76 36 81.6 77 37 83.7 79 1.0 a) What portion of the variation in the 2.0 1.0 c) Based on this model, productivity 1.0 d) Based on this model, productivity 1.0 e) Comment on the quality of your reg F23 Regression Output b) What output would you expect for is making $55,450?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Age (A) Income (I) 60 22.1 59 24.6 59 25.1 53 28 52 28.3 50 29.7 50 32.1 49 32.6 49 33.7 49 44.1 48 42.9 47 40.7 47 40.2 45 40 45 39.9 43 39.6 43 38.5 41 38.4 40 38 40 37.4 40 34.5 etween the productivity of your sales staff and some other factors such as the number of training hours, age, and cted the data of 37 employees. The Output is the percent of actual sales given the sales leads. You want to study put. For example, does age matter? And if it does, are the younger employees better performers than the older eets. That means do not add or delete columns or r
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
40 34.4 40 44.4 35 44.6 35 44.8 35 44.8 36 45.6 37 46.5 38 47.5 39 49 39 51.4 39 52.6 34 52.9 34 54.8 33 55.1 31 55.2 30 55.6 e Output is explained by the 3 independent variables? gression result. That is, how strong or weak it is? a 40-year old employee who has 50 hours of training and
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
d the y the rows. D O N OT ch an ge th e str uc tur e of th e sh ee ts. Th at m ea ns do no t ad
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ad d or del et e col u m ns or ro ws . ` D O N OT ch an ge th e str uc tur e of th
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
th e sh ee ts. Th at m ea ns do no t ad d or del et e col u m ns or ro ws . `
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

PH1700_Answer_Key_Exercises in Preparation for Midterm_10_05_2022_03.pdf
2.docx
Condo Sales Case Study.docx
New Final CJ350 Project IBR (1).docx
Case Study 1-Dylan Harloff.docx
Statistics Homework Assignment Three (3).docx
SPH244_2023_Homework_6.docx
T Distribution Formula - What Is It, Examples, Relevance.pdf
BIOL 4254 Stats Homework - CASEY NOYES.docx
BIOL 4254 Life tables HW - CASEY NOYES.docx
Lab 4 .Rmd
Chapter 4 HomeworkKey.pdf
Related Questions
help
Thanks
Solve. (Enter your answers as a comma-separated list.) 6.5 – 40,566.5x-2 = 0 X =
X CR CCPS 1205040 M/I Grade 7 x Clask | Single Sign-On for Ed x a CCPS a r02.core.learnedgenuity.com/Player/ Finding the Expression Jonah buys a television that costs $445. Sales tax in his state is 7 percent. Which of the following expressions represent the amount of tax on the television? Select all that apply.N O Tax = 445(7) %3D O Tax = 445(0.07) O Tax = 445(7/100) %3D O Tax = 445 - 0.07 %3D O Tax = 445 + 0.07 %3D 552 AM N 74'F Rain to stop 6/24/2021 P Type here to search DELL E R T Y] K B Alt All Ciri
Q2 needed to be solved correctly in 30 minutes and get the thumbs up please show neat and clean work
A long year-end status report for work is 157 pages long. You need to print 16 copies for a meeting next each. week. How much is the paper going to cost for those reports? Paper is sold in reams (500 pages) for $3.28 Give your answer to the nearest cent, only for the paper you use (partial reams are OK) Question Help: Message instructor A'F2 @ Submit Question N Z w S alt X "F3 3 E W hs D 9*4 X $ с R 0 X F5 - % 5 V G F7 B & 8. 7 F8 A * 8 Z prt sc 10 home K me11 0 end F12
Identify the domain
Hi, I am really stuck on these three questions. I have looked through all my notes and work that I have done and I can’t seem to find anything quite like this problem.  The first photo is the background information and the second photo is the questions that I am stuck on.
Help step by step explanation written
A survey found that Massachusetts residents spent an average of $861.75 on the lottery, more than three times the U.S. average. A researcher at a Boston think tank believes that Massachusetts residents spend less than this amount. He surveys 100 Massachusetts residents and asks them about their annual expenditures on the lottery. (You may find it useful to reference the t table.)   Click here for the Excel Data File (The Lottery data below is from the excel file) a. Specify the competing hypotheses to test the researcher’s claim.multiple choice 1 H0: μ = 861.75; HA: μ ≠ 861.75 H0: μ ≥ 861.75; HA: μ < 861.75 H0: μ ≤ 861.75; HA: μ > 861.75 b-1. Calculate the value of the test statistic. (Negative value should be indicated by a minus sign. Round final answer to 3 decimal places.) Test statistic=     Lottery 787 605 919 1140 1090 1191 405 795 1050 644 699 518 469 654 708 405 747 791 880 751 795 803 1103 823 765 744…
Please solve the questions I have attached the data in the screenshot and the codes that can be used for the questions.    Thank you.
Hi could you fill this out?
need help asap
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
College Algebra
Algebra
ISBN:9781337282291
Author:Ron Larson
Publisher:Cengage Learning
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Text book image
Intermediate Algebra
Algebra
ISBN:9781285195728
Author:Jerome E. Kaufmann, Karen L. Schwitters
Publisher:Cengage Learning
Text book image
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Related Questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
College Algebra
Algebra
ISBN:9781337282291
Author:Ron Larson
Publisher:Cengage Learning
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Text book image
Intermediate Algebra
Algebra
ISBN:9781285195728
Author:Jerome E. Kaufmann, Karen L. Schwitters
Publisher:Cengage Learning
Text book image
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
SEE MORE TEXTBOOKS