Collect sufficient data about any two quantitative variables (logically correlated)using reasonable sets of values (At least 15 values).Use Microsoft Excel and answer the following:Firstly: Determine the independent variable and the dependent variable.Secondly: Make the correlation analysis for the quantitative variables anddetermine the correlation coefficient, and interpret it.Thirdly: Do the regression analysis and answer the following questions:1. What is the type of regression in your example?2. Find the sample size.3. Find the degrees of freedom.4. Is your model valid? Why?5. Find the value of the coefficient of determination, and interpret it.6. Is the independent variable having a significant effect on the dependentvariable? Why?7. Write down the regression line equation.8. Estimate the value of ŷ if the value of X is 20.

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

Collect sufficient data about any two quantitative variables (logically correlated) using reasonable sets of values (At least 15 values). Use Microsoft Excel and answer the following: Firstly: Determine the independent variable and the dependent variable. Secondly: Make the correlation analysis for the quantitative variables and

Collect sufficient data about any two quantitative variables (logically correlated) using reasonable sets of values (At least 15 values). Use Microsoft Excel and answer the following: Firstly: Determine the independent variable and the dependent variable. Secondly: Make the correlation analysis for the quantitative variables and

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Consider the following OLS regression results, 9-10.46+0.271x, R² -0.13. Calculate the predicted value of y when x is equal to 16. Round to the nearest tenth (one decimal place).
Use a graphing calculator to create a scatter plot and find the line of best fit and the correlation coefficient for the following data. Round to the nearest hundredth. X 5 10 15 20 25 30 35 y 1,800 1,750 1,590 1,490 1,400 1,275 1,010
Attendance at Orlando's newest Disneylike attraction, Lego World, has been as follows Quarter Guests (in thousands) Quarter Summer Year 2 Winter Year 1 58 99 Fall Year 2 149 Winter Year 3 Spring Year 1 Summer Year 1 Fal Year 1 Winter Year 2 75 Spring Year 3 63 Summer Year 3 Spring Year 21 82 Fall Year 3 Based on the given attendance, the seasonal indices for each of the seasons are (round your responses to three decimal places) Season Index Winter Spring Summer Fall 0000 Guests (in thousands) 125 54 99 146 210 99
Global Bikes Inc. (a bicylce manufacturing firm) collected the following data during a study of consumer buying patterns. Observation 1 2 3 4 5 6 7 y= X y 15 70 28 79 38 89 35 86 49 97 42 97 30 82 y = Observation 0.721 + 1890123 a. Create a linear regression line (equation) for the data.(Round your Intermediate calculations and final answers to 3 decimal places.) X 14 16 14 24 21 29 63.229 X y 82 70 68 84 83 91 b. Use the equation determined in part b to predict the expected value of y for x = 49. (Round your Intermediate calculations and final answers to 3 decimal places.)
1 3. 4 y 703 3295 8279 14390 25470 37673 Use linear regression to find the equation for the linear function that best fits this data. Round to two decimal places.
rescarcher wanted to study if family factors had an impact of academic achievement. The family factors investigated were family income, parents' level of education, parents' support and encouragement to their children, and parents' interests in their children education. Answer the Questions 1 to 4 only from the above information: Q.1 Write the objective of research. Q.2 Write any two possible independent variables. Q.3 Write the possible dependent variable. Q.4 Write the relationship between the variables.
The following table shows a company's annual revenue (in billions of dollars) for 2009 to 2014. Year Period (t) Revenue ($ billions) 2009 1 23.8 2010 29.2 2011 37.9 2012 4 50.3 2013 59.8 2014 6 66.6 (a) Construct a time series plot. 80 80 70 70 70 70 60 60 50 50 50 30 30 30 30- 20 20 20 20 10 10 10 - 10- 4. 6 7 4 6 4 5 6 7 1 2. 4 6 7 Period Period Period Period What type of pattern exists in the data? O The time series plot shows an upward linear trend. O The time series plot shows a downward curvilinear trend. O The time series plot shows a downward linear trend. O The time series plot shows an upward curvilinear trend. (b) Develop a linear trend equation for this time series to forecast revenue (in billions of dollars). (Round your numerical values to three decimal places.) T = (c) What is the average revenue increase per year (in billions of dollars) that this company has been realizing? (Round your answer to three decimal places.) billion Revenue ($ billions) Revenue ($ billions)…
Please help me with thirdly part 1,2, and 3
What is the recommended sequence of building predictive model ? which answer choice? Model Evaluation > Data Preparation > Model Training > Data Sampling Model Evaluation > Data Preparation > Data Sampling > Model Training Data Sampling > Data Preparation > Model Training > Model Evaluation Data Sampling > Data Preparation > Model > Model Evaluation > Model Training
Solve for the y-intercept and the slope. Form the equation of the regression line that describes the relationship between the two variables. Predict the profit of the fashion boutique business when the store measures 3,800 square feet. Explain the result.
What is the advantages of using predictive analyctics? Explain in 250 words. Say that it improves decision making, making competitive advantage, improves risk management, and others.
Based on the following regression ANOVA table, how many predictors are studied? Source df SS MS F Regression 4 1793.2356 448.3089 7.4854 Residual 45 2695.0996 59.8911 Total 49 4488.3352 1 3 4 5