Answered: Consider this data: МАTH SCIENCE… | bartleby

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter10: Statistics

Section10.2: Representing Data

Problem 10PPS

See similar textbooks

Related questions

Question

Show answer in microsoft excel

Consider this data:
МАТH
SCIENCE
FILIPINO
ENGLISH
А.P
NAME
GRADE
GRADE
GRADE
GRADE
GRADE
MARK
75
70
78
81
78
PETE
84
87
86
88
85
ANA
91
92
95
90
90
REA
73
75
74
75
70
Give the formulas to get :
Mark's , Pete's, Ana's and Rea's
averages
The highest grade that Ana got
The lowest grade that Mark got?
Sum of all Math Grade? Science? A.P.?
Sum of all Rea's Grades
The Lowest Number among all grades
The remarks (Passed or Failed)
Now, consider this data:

The remarks (Passed or Failed)
Now, consider this data:
FIRST
MIDDLE
LAST NAME
NAME
NAME
MARK
CURTIS
WILLIAMS
PETE
MCCLOEY
HARRISON
ANA
MONROE
FRITZ
REA
TAN
COLLINS
Give the formulas to get :
• Mark's Full Name
• Ana's Full Name in Proper Case
Count the number of letters that Pete's
Last Name has
• "COLL" from Rea's Last Name
• “LOEY" from Pete's Middle Name
Combining "WILL" and "LINS" from Mark
and Rea's Last Names respectively

Expert Solution

Step by step

Solved in 4 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Blurred answer

Similar questions

The management of a supermarket wants to find if there is a relationship between the number of times a specific product is promoted on the intercom system in the store(x) and the number of units of that product sold (y). To experiment, the management selected a product and promoted it on the intercom system for 7 days, recording the number of times this product was promoted each day and the number of units sold. Summaries of a study conducted gave the following results: ∑x=177, ∑y= 144, SSxx=809.4286, SSyy=261.7143, SSxy= 407.8571 a) Calculate the correlation coefficient (r) relating number of times this product was promoted each day and the number of units sold. b) Find the regression line.
The Admission director for a college far from mart and town believes that an inverse relationship exists between a private college's average discount rate(determined by the average amount of scholarships students receive) and the annual yield (the percentage of admitted students who actually attend). The Director's independent variable is a private college's discount rate measured as a percentage, and the dependent variable is the college's annual yield measured as a percentage. The following results were obtained for a sample of 30 private colleges: x- Discount rate(percentage) - range: 35 to 72 percent y- Annual Yield(percentage) - range: 12 o 81 percent Σxi = 1612 Σyi = 898 Σxiyi = 44,377 Σxi2 = 89,790 Σyi2 = 35,704 a. Calculate the sample regression line's slope estimate. Interpret the sample regression line's slope estimate. b. Calculate the sample regression line's intercept estimate. Interpret the sample regression line's intercept estimate. Assume the following sum of…
A student would like to know which establishment would allow him to save more money from everyday food costs. He is choosing between AVM or Hollywood Terraces, so he traced his spending in both establishments for 1 school week each, his data is as follows: AVM: 97, 85, 69, 105, 105 HT: 60, 45, 60, 75, 100 Find out if there is a significant difference in his spending between the two food courts.
Please give the first Q1 for this data
T6 Data 348.5 354 361 365.5 380 413.2 417.4 439.1 445 468.8 472.7 473.9 477.3 477.3 477.3 478.6 479.2 480.8 481 481.4 481.5 482.8 484.1 484.2 485.2 485.9 488.9 488.9 489.7 490 490.7 503 509.5 512.8 516 523.5 524.6 529.8 535.7 541.7 541.7 541.7 548.6 560 577.3 578 589.6 597.7 599.4 600.3 604.2 609 615.8 625.4 this is the data set for #6
Describe about the three positive relationships of Scatterplots?
Ernesto is a web developer who is looking to determine which of two types of advertisements are the most cost effective. He suspects that advertisements with animations generate more clicks than advertisements without animations but wants to confirm his intuition before he starts recommending advertisements with animations to his clients. Ernesto creates advertisements with animations for 12 different products and then creates advertisements without animations for those same products. Then he measures the click-through rate for those advertisements. The data are provided below (given as percentages of total visitors to the site who clicked on the advertisement). Assume that the conditions required for this hypothesis test are satisfied. Use a calculator to test the paired data, where α=0.01. Compute the sample differences d using d=Without−With. Which of the following statements are accurate for this hypothesis test in order to evaluate the claim that the true mean difference between…
A data set with r = 0.9 has a stronger fit than a data set with r = –0.9. True or false?
Would the number of items in your grocery cart be discrete or continuous data?
ABC company has recently experienced a sharp decline in its stock price. Its current (time 0) stock price is $42.65, and this morning, it paid $5.00 per share. Given that the stock price four years ago was $82.88, complete the following time series of data by determining the missing values. t= -3, Pt =$83.43, Divt = $16.03, Rt = (1)t= -2, Pt =$85.20, Divt =(2), Rt = 22.8482%t= -1, Pt =(3), Divt =$17.50, Rt = 20.6572%t= 0, Pt =$42.65, Divt =$5.00, Rt =(4)
A farmer would like to investigate the relationship between the obtained yield of apple trees and the amount of weeds found in their roots. For this reason, nine apple trees of the same type were randomly selected and the amount of weeds in their roots (x grams) was recorded together with their yield (y kilograms). Year #1 #2 #3 #4 #5 #6 #7 #8 #9 #10 Weeds in roots (x) 30 28 32 25 25 24 22 24 35 40 Yield (y) 25 30 27 40 42 41 50 45 30 25 Draw a scatter diagram of these data. Label the diagram carefully. Calculate the sample correlation coefficient. Interpret your findings. Calculate the least squares line of y on x and draw the line on the scatter diagram. Based on the regression equation in part (iii.), what will be the predicted yield of apple for a tree with 37 grams of weeds in its roots? Will you trust this value? Justify your answer. Briefly comment on…
The demand for hand sanitizers is off the charts due to this coronavirus outbreak. People are in desperate need of hand sanitizers. Therefore, FMCGs like Unilever Bangladesh Limited are producing this life-essential product in a bulk amount to help the citizens across Bangladesh to maintain the hygiene standards. Sales figures and profits for the stores are given in the following table. (For the Unit sales, pick any value in between 12-33Units in ascending order). Unit Sales, X Profit (Taka), Y ** 1200 ** 1650 ** 1950 ** 2300 ** 2700 ** 3600 ** 4100 Obtain a regression line for the data. Calculate the profit of a shop for 40 unit sales. Calculate the correlation between unit sales and profit. What is the coefficient of determination of these variables?

SEE MORE QUESTIONS

Recommended textbooks for you

Glencoe Algebra 1, Student Edition, 9780079039897…

Glencoe Algebra 1, Student Edition, 9780079039897…

Algebra

ISBN:

9780079039897

Author:

Carter

Publisher:

McGraw Hill

Algebra & Trigonometry with Analytic Geometry

Algebra & Trigonometry with Analytic Geometry

Algebra

ISBN:

9781133382119

Author:

Swokowski

Publisher:

Cengage

Glencoe Algebra 1, Student Edition, 9780079039897…

Glencoe Algebra 1, Student Edition, 9780079039897…

Algebra

ISBN:

9780079039897

Author:

Carter

Publisher:

McGraw Hill

Algebra & Trigonometry with Analytic Geometry

Algebra & Trigonometry with Analytic Geometry

Algebra

ISBN:

9781133382119

Author:

Swokowski

Publisher:

Cengage

SEE MORE TEXTBOOKS