o help consumers in purchasing a laptop computer, Consumer Reports calculates an overall test score for each computer tested based upon rating factors such as ergonomics, portability, performance, display, and battery life. Higher overall scores indicate better test results. The following data show the average retail price and the overall  score  for  ten  13- inch  models  (Consumer Reports website, October 25, 2012).  solution must be in excel format Brand & Model Price ($) Overall Score Samsung Ultrabook NP900X3C-A01US 1250 83 Apple MacBook Air MC965LL/A 1300 83 Apple MacBook Air MD231LL/A 1200 82 HP ENVY 13-2050nr Spectre XT 950 79 Sony VAIO SVS13112FXB 800 77 Acer Aspire S5-391-9880 Ultrabook 1200 74 Apple MacBook Pro MD101LL/A 1200 74 Apple MacBook Pro MD313LL/A 1000 73 Dell Inspiron I13Z-6591SLV 700 67 Samsung NP535U3C-A01US 600 63  a. Develop a scatter diagram with price as the independent variable. b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables? c. Use the Least Squares method to develop the estimated regression equation.

Q: a. What are the estimated sales for the Bryne store, which has four competitors, a regional…

A: “Since you have posted a question with multiple sub-parts, we will solve first three subparts for…

Q: A business with 150 workers pays 113 employees P45.50 per hour and 37 employees P51.25 per hour.…

A: Given  n=113, X1=45.5, n=37, X2=51.25  We want to calculate average.

Q: An employee had accumulated 20 competency credits with the grade with B's, 10 credits with C's, and…

A: make a table as shown  grade grade points credits earned grade point×credit A 4 20 80 B 3 25…

Q: one standart?

A: here use Empirical rule

Q: Almost all U.S. light-rail systems use electric cars that run on tracks built at street level. The…

A: Simple linear regression model: A simple linear regression model is given as y^ = b0 + bx + e…

Q: In essence, how does the student’s employment and driving distance affect how many purchases they…

A: Given: In includes the value of the student’s employment and driving distance that gets affected. To…

Q: Almost all U.S. light-rail systems use electric cars that run on tracks built at street level. The…

A: Simple linear regression model: A simple linear regression model is given as y^ = b0 + bx + e…

Q: How much would Skylar have to pay in a month where she used 5 GB over the limit?

A: Cost of using 7GB data = 50 $Cost of using extra GB after consumption of 7 GB = 30 $ per GBa.)She…

Q: There were 3-wheel ATV’s and 4-wheel ATV’s at the fall of road exhibition. Justin counted a total of…

A: Make linear equations in two variables accordingly to the question.

Q: Expressed as Percantage of selling price, which of the best selling menu items is the most costly to…

A: We have to answer question based on given table.

Q: A college conference has total 160 papers, with 25 papers more from mathematics department than…

A: let, x is number of mathematics paper y is number of statistic paper

Q: Of the trains that recently arrived at Hampton Station, 4 were on time and 2 were late. Considering…

A:

Q: To help consumers in purchasing a laptop computer, Consumer Reports calculates an overall test score…

A: In this problem we have observations on two variables price and score of laptop or computers. We are…

Q: A national chain of department stores ranks its 1,000,000 salespeople by the monetary value of their…

A: Given Data: Boris sales at 89th percentile Melissa's sales at 73rd percentile

Q: A teacher attaches 2 to quiz, 3 to midterm and 5 for final exam. If a student gets 90, 50 and 60 for…

A: As per our guidelines, we are allowed to answer first question only. Thanks 1) A teacher attaches 2…

Q: In 2015, the median family income in the United States was $66,650. (Source: U.S. Census Bureau) If…

A: Given information Median family income $66,650 Median income means 50th percentile

Q: A survey estimated that the average cost of textbooks for a semester of college is $320 with a…

A: Given The average cost of textbook for a semester of college is $320 So x¯ = 320 Margin of error E…

Q: Going into the final exam, which will count as two tests, Brooke has test scores of 80, 83, 71, 61,…

A: To find: The final score to achieve the average score of 80. Given: The Person B test scores are…

Q: On Monday evenings in April 2015, each episode of WWE Entertainment was typically watched by 3.8…

A: Given:

Q: The average score of lovelyn in 6 math quizzes is 19. If she will not include her lowest score, her…

A: Let her lowest score be x and the other scores be a,b,c,d,e.

Q: At a competitive examination at which 600 graduates appeared, boys outnumbered girls by 96.

A: It is asked to find the number of boys who qualified for the interview. Let's assume,  N = Total…

Q: A Correctional Psychologist wants to compare the number of criminal convictions of Persons Deprived…

A: Given information: The data represents the values of the variables number of criminal convictions,…

Q: John has grades of 86, 88, and 78 on his first three tests in geometry. If he wants an average of at…

A:

Q: The number of megapixels in a digital camera is one of the most important factors in determining…

A: Correlation is the measure that used to understand the association between the two numerical…

Q: Molly recorded how many nuts of each type she blindly grabbed from a can of mixed nuts.     walnuts…

A: The probability of walnuts is 50/100 =1/2

Q: The Zagat Restaurant Survey provides food, decor, and service ratings for some of the top…

A: Hi! Thank you for the question, As per the honor code, we are allowed to answer three sub-parts at a…

Q: The test statistic for the rhino data, x^2= 3.85, suggests that:

A: Given that, The test statistic for the rhino data, x^2= 3.85,

Q: The chart shows the percent of people that use each different type of browser. If 8,000 people were…

A: To Determine: how many selected chrome? Given: we have 8,000 people were surveyed. Explanation: we…

Q: An auto parts store operated 3528 stores in 2004. By 2007, the auto parts store operated 4110…

A: Let the the number of stores followed a following linear pattern y = ax +b  ....... (1) Where x =…

Q: An investor bought common stock of Blackstone Company on several occasions at the following prices.…

A: The following table provide the price and corresponding number of share is given by:

Q: An ice cream shop examines the orders of his customers, and noticed that: • All his customers bought…

A: “Since you have posted a question with multiple sub-parts, we will solve the first three subparts…

Q: An airline food service found that a recent flight of 120 passengers ordered dinner as depicted in…

A:

Q: On the TV show, The Biggest Loser, the winner is the person who lost the largest percentage of…

A: The initial weights of Courtney, Patrick and Antone are 270 lb, 387 lb and 447 lb respectively. The…

Q: The discharge analysis report of Anywhere Health Care Facility shows 1752 discharges (including…

A: Point estimate: It is defined as the numeric value that provides estimate of value of the…

Q: A study of damages awarded by judges in civil cases such as injury, factory liability, or medical…

A: Mean is defined as the simple mathematical average computed by dividing total observations by the…

Q: A major league baseball team is ending its season and totaling up concession sales. Looking at…

A: Solution is in step 2

Q: All of the 1,020 students at a local high school must enroll in a foreign language course. If 269…

A: The detailed solution is given in the next step.

Q: The basketball coach at a local college believes that his team scores more points at home games when…

A: Calculate the following values through excel. X Y (xi - mean_x)2 (yi - mean_y)2 (xi - mean_x)*(yi…

Q: The elevations of three cities in the Netherlands are shown below. Which comparison is true?…

A: Elevations of three cities.

Q: To get to know her students better, Ms. Wilse surveyed her math students to determine wl hobbies and…

A: Given data, P(Students prefer arts or donesnot prefer literature)=?

Q: Lastly find two customers who set a favorite menu items on the equivalent or equal.

A: Explanation are as follows

Q: the highest data of 50 leaves is 150mm and the lowest is 118m the desired class size is 9

A: Given  N=50 Highest value=150  Lowest value=118  Class size=9

Q: The U.S. Census Bureau collects data on household size and publishes the information in Current…

A: Quantitative variable: The variable which can be measured using the number is called the…

Q: The SM Shopping Mall conducts special events to attract potential patrons to its premises. The two…

A:

Q: To help consumers in purchasing a laptop computer, Consumer Reports calculates an overall test score…

A: Given table :   price (x) score (y) x-xy-y 1250 83   1300 83   1200 82   950 79   800…

Q: Twenty percent of anthropology majors were offered a starting salary greater than .

A: Given that  Mean = M = 39269 Standard deviation = SD =2550 X ~ Normal ( M = 39269 , SD = 2550 )

Q: The boxplots show the daily attendance for two fitness gym for one month. Fitness Club Daily…

A:

Q: A bicycle manufacturer observes that the number of bike paths in a city affects the number of…

A: here take  x= no. of bike paths y= no. of bicycle sold here compute the regression line and then for…

Q: The scatter plot shows the total number of rebounds caught and the total number of points scored for…

A: In the scatterplot the rebound are plotted on horizontal axis and points are plotted on vertical…

Q: she will need?

A: