Using your excel spread sheet from week 4 - graph your data in a linear scatter plot


Using your excel spread sheet from week 4 - graph your data in a linear scatter plot

To Purchase This Material Click below Link

http://www.tutorialoutlet.com/all-miscellaneous/using-your-excel-spread-sheet-from-week-4-graph-your-data-in-a-linear-scatter-plot/

FOR MORE CLASSES VISIT

www.tutorialoutlet.com

1. Using your excel spread sheet from week 4 - graph your data in a linear scatter plot

2. Make sure you label the graph, correctly label the x and y sides. For example if you are doing the voluime os sale of a particular car. Your x values will be the years of data that you found (1998, 1999, 2000, 2001, etc) and the Y will be the sales volume ( 100 mil, 200 mil, 300mil, etc).

3. Find the trendline associated with the scatter plot.

4. Using the data points find the slope using different data points and compare these values for slope with the value found using the trendline in Excel. Find the at least 2-3 different values for slope using the data you found

5. estimate the possible y values(outcome) in 5 years from your last data point and for 10 years from your last data point

6. Discuss the whether the data follows a linear trend.

Comments

Post a Comment

Popular posts from this blog

write a program that uses a structure named MovieData to store the following information about a movie

write a program that uses a structure named MovieData to store the following information about a movie To Purchase This Material Click below Link http://www.tutorialoutlet.com/all-miscellaneous/write-a-program-that-uses-a-structure-named-moviedata-to-store-the-following-information-about-a-movie/ FOR MORE CLASSES VISIT www.tutorialoutlet.com 1- write a program that uses a structure named MovieData to store the following information about a movie: o Title o Director o Year Released o Running Time (in minutes) 2- The program should create 2 MovieData variables, store values in their members, and pass each one, in turn, to a function that displays the information about the movie in a clearly formatted manner. use the C++ language. I want to create structure to store the information about the movies please follow the requirements above thanks
Read more

You are presented with the following reports estimating the mean increase in monthly household spending on gasoline over the past six months

You are presented with the following reports estimating the mean increase in monthly household spending on gasoline over the past six months To Purchase This Material Click below Link http://www.tutorialoutlet.com/all-miscellaneous/you-are-presented-with-the-following-reports-estimating-the-mean-increase-in-monthly-household-spending-on-gasoline-over-the-past-six-months/ FOR MORE CLASSES VISIT www.tutorialoutlet.com You are presented with the following reports estimating the mean increase in monthly household spending on gasoline over the past six months. Determine which report you find most convincing and explain your reasoning. 1. Based on a simple radom sample of 15​ households, we are​ 98% confident that the mean increase in monthly household spending on gasoline over the past six months is between​ $43.65 and​ $58.93. 2. Based on a simple random sample of 52​ households, we are​ 95% confident that the mean increase in monthly household spending on ga...
Read more

What is the probability that all three randomly selected households own a van

What is the probability that all three randomly selected households own a van To Purchase This Material Click below Link http://www.tutorialoutlet.com/all-miscellaneous/what-is-the-probability-that-all-three-randomly-selected-households-own-a-van/ FOR MORE CLASSES VISIT www.tutorialoutlet.com Suppose that a recent poll of American households about car ownership found that for households with a​ car, 39% owned a​ sedan, 33% owned a​ van, and​ 7% owned a sports car. Suppose that three households are selected randomly and with replacement. What is the probability that all three randomly selected households own a​ van? (Round to the nearest​ thousandth)
Read more