Sales for last 10 weeks are shown in the table below. Plot the data and visually check to see whether a linear trend line is appropriate. Then determine the equation of trend line, and predict sales for weeks 11 and 12. Week 1 2 3 4 5 7 8 | 9 10 Unit 700| 724 720| 728 | 740 742| 758 | 750 | 770 | 775 CO LO

Q: The equation of the trend line for the data based on sales (in $1000) of a local restaurant over the…

A: The trend line for the sales is given as       Sales = -265575+132.571*year

Q: 3. When Hana goes to the mall, she always buys the same lunch and also buys some books. The table…

A: Given, x 1 2 2 3 4 y 17 21 23 26 34 Mean of x values = 125= 2.4Mean of y values = 1215=24.2

Q: Create a 2-D line chart of Cash Sales for months 1-18. Add a trend line with a forward forecast of 3…

A: Given Information: Consider the given data: Months Cash Sales 1 2145600 2 2175200 3 2255200…

Q: Rick is a school principal, and he is trying to decide if there is a relationship between conduct…

A: We plot number of infractions on x-axis and number of student present in the school on the y-axis.

Q: Find correlation and use excel

A: The data set is: x y 19 30 21 24 25 28 22 31 33 35

Q: Given this data visualization, create the frequency table that best describes it. Age 12 10 8. 6. 4…

A:

Q: The scatterplot below shows the sales for a flower company for the years 2007 through 2012. Use a…

A: Let t denote the time period in years, & Y denotes the sales (in thousands). The linear relation…

Q: 2 3 4 5 6 7 51 49 48 46 43 40 The equation for the line of best fit is y = x + 0=0 X S

A:

Q: Draw a scatter plot for the given data. -1 2 10 y -4 1 5 7 8. 3.

A: The given points are: -1,-4, 1,0, 2,35,1, 8,5, 10,7

Q: The accompanying scatterplot shows data on age, denoted A, of a sample of students and the number of…

A: A scatterplot is a graphical representation which shows the graphical representation b/w 2…

Q: Create a scatter plot from the following data. Use your plot to comment on the relationship between…

A: Step 1: State the given table: Let x = speedLet y = Miles per gallon or MPG Step 2: Plot data points…

Q: The table below shows the expected years remainıng in a person's life given a person's curent age.…

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

Q: The table to the right shows teenage drug use in different countries. Make a scatter plot for the…

A:

Q: Use a graphing calculator to create a scatter plot and find the line of best fit for the following…

A:

Q: A scatter plot would be useful for:     Showing the relationship between the sales of blank CDs and…

A: The objective is to find the correct option for the scatterplot.

Q: /hich of the following best describes the trend of the graph? atterplet of High School GPA vs Shoe…

A: For positive trend, the data points are distributed in upward direction form. For negative trend,…

Q: Using the accompanying Student Grades data, construct a scatter chart for midterm versus final exam…

A: The regression line of Y on X is, Y=a+bXwhere a=intercept of regression line            b=slope of…

Q: The following table gives the average monthly exchange rate between the U.S. dollar and the euro for…

A: The given data is as follows: January1.289February…

Q: Ans. d. Use Excel to find the coefficient of determination r?. Ans. e. What % of the variation can…

A: We are given with the data from that we can calculate R2 i.e. Coefficient of determination  The…

Q: 4. The MyTunes song app sells music downloads. Over the past few years, the service has lowered its…

A:

Q: 9. a. Obtain the linear trend equation for the following data on new checking accounts at Fair…

A: PeriodNew accounts120022143211422852356232724882509253102671128112275132801428815310

Q: A professor went to a website for rating professors and looked up the quality rating and also the…

A: The linear correlation coefficient (ρ) is a measure of strength of the linear relationship between…