Question

In: Accounting

For this problem you will be creating your own linear model for data of your choosing....

For this problem you will be creating your own linear model for data of your choosing. Please do the following: • Find a data set that you believe to be linear. You can measure and collect your own data or search the internet. Be sure to cite where you get your data. • Plot the data on a coordinate plane. Include a link to this graph in your submission of this assignment. • Approximate a slope and intercept for your data then write the equation for the line. You can plot the line on the graph of your data. • Reflect on the process and tell me about your solution. Is it accurate? Can it predict unknown values? What are its limitations?

Solutions

Expert Solution

Model specification is the process of determining which independent variables to include and exclude from a regression equation. How do you choose the best regression model? The world is complicated, and trying to explain it with a small sample doesn’t help. In this post, I’ll show you how to select the correct model. I’ll cover statistical methods, difficulties that can arise, and provide practical suggestions for selecting your model. Often, the variable selection process is a mixture of statistics, theory, and practical knowledge.

The need for model selection often begins when a researcher wants to mathematically define the relationship between independent variables and the dependent variable. Typically, investigators measure many variables but include only some in the model. Analysts try to exclude independent variables that are not related and include only those that have an actual relationship with the dependent variable. During the specification process, the analysts typically try different combinations of variables and various forms of the model. For example, they can try different terms that explain interactions between variables and curvature in the data.

The analysts need to reach a Goldilocks balance by including the correct number of independent variables in the regression equation.

Too few: Underspecified models tend to be biased.
Too many: Overspecified models tend to be less precise.
Just right: Models with the correct terms are not biased and are the most precise.
To avoid biased results, your regression equation should contain any independent variables that you are specifically testing as part of the study plus other variables that affect the dependent variable.

Statistical Methods for Model Specification
You can use statistical assessments during the model specification process. Various metrics and algorithms can help you determine which independent variables to include in your regression equation. I review some standard approaches to model selection, but please click the links to read my more detailed posts about them.

Adjusted R-squared and Predicted R-squared: Typically, you want to select models that have larger adjusted and predicted R-squared values. These statistics can help you avoid the fundamental problem with regular R-squared—it always increases when you add an independent variable. This property tempts you into specifying a model that is too complex, which can produce misleading results.

Adjusted R-squared increases only when a new variable improves the model by more than chance. Low-quality variables can cause it to decrease.
Predicted R-squared is a cross-validation method that can also decrease. Cross-validation partitions your data to determine whether the model is generalizable outside of your dataset.
P-values for the independent variables: In regression, p-values less than the significance level indicate that the term is statistically significant. “Reducing the model” is the process of including all candidate variables in the model, and then repeatedly removing the single term with the highest non-significant p-value until your model contains only significant terms.

Stepwise regression and Best subsets regression: These two automated model selection procedures are algorithms that pick the variables to include in your regression equation. These automated methods can be helpful when you have many independent variables, and you need some help in the investigative stages of the variable selection process. These procedures can provide the Mallows’ Cp statistic, which helps you balance the tradeoff between precision and bias.


Related Solutions

Creating a study of your choosing, how would you consider false positives in your sample data...
Creating a study of your choosing, how would you consider false positives in your sample data and how would you account for them in your overall interpretation of the results of your study?
Creating a study of your choosing, how would you consider false positives in your sample data...
Creating a study of your choosing, how would you consider false positives in your sample data and how would you account for them in your overall interpretation of the results of your study?
QUESTION 17 The process of creating a linear model of bivariate data. a. Least Squares Regression...
QUESTION 17 The process of creating a linear model of bivariate data. a. Least Squares Regression b. Variability c. Extrapolation d. Residual analysis QUESTION 18 The "Portion of Variability" is also known as the a. Correlation coefficient b. Regression line c. Fitted Value d. Coefficient of determination QUESTION 19 Linear regression models may not always acccurately reflect the pattern of data from which they are made a. TRUE b. FALSE QUESTION 20 The following data relates the time a student...
In this discussion, you will be creating your own application problems that your fellow classmates will...
In this discussion, you will be creating your own application problems that your fellow classmates will solve using systems of linear equations. Let’s first look at an example. When creating an application problem, it is helpful to begin with the solution to the problem. So, for example, if you start with the solutions (a rectangular garden with width = 8 ft, length = 10 ft), then you must find two ways these quantities relate to each other and give this...
What is the model for this linear programing problem?
What is the model for this linear programing problem?
How would you go about creating a linear regression model to predict the 2020 Presidential Election?
How would you go about creating a linear regression model to predict the 2020 Presidential Election?
Examine your classmate’s problem to assess the appropriateness and accuracy of using a linear regression model....
Examine your classmate’s problem to assess the appropriateness and accuracy of using a linear regression model. Discuss the meaning of the standard error of the estimate and how it affects the predicted values of Y for that analysis. The problem I am interested in dealing with is the rate of illnesses as it compares to people that do or do not wash there hands frequently. This data would be collected throughout the year to see if there is a correlation...
Problem 3 (A Real Data Application). Recall in the simple linear regression model in Module 3,...
Problem 3 (A Real Data Application). Recall in the simple linear regression model in Module 3, I gave a real data example using the Nobel-winning Capital Asset Pricing Model (CAPM). In that example, we obtained R2 = 0.108, or 10.8%, which is a small value way less than 100%. This means that the single independent variable, the market return, RM, does not explain the return of an individual stock or portfolio very well in this simple linear regression model. Researchers...
Suppose you were given an opportunity to own a business of your choosing. First, briefly describe...
Suppose you were given an opportunity to own a business of your choosing. First, briefly describe your business; then explain the most efficient way to raise capital to either start or expand your business. Provide support for your response. Please Note- You just need to choose one way, and explain why the option selected is most efficient. Also, state whether capital is for starting or expanding the business.
You can select an operations management environment of your own choosing, however ensure it is realistic...
You can select an operations management environment of your own choosing, however ensure it is realistic and real world applicable, reflecting good judgment, business sense, and critical thinking skills. Consider the following topic and follow the instructions below; remembering to complete all elements of your Assessment: Facility Design Create a facility design within an operations management environment, using real world research to support your work. At the beginning of your paper, introduce your planned work, to include a description of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT