column (bar) chart DJ needs to display data over time. Which of the following charts should DJ use? line chart Looking at the following chart showing time series data for regular gasoline prices in the United States for 24 consecutive months, you can make this interpretation about gas prices: Overall the price of gasoline was extremely consistent during the time period shown. FALSE Which of the following can be used to show overall trend? spark lines A PivotChart is a graphical presentation created in Excel that functions similar to a PivotTable. __________ is a statistical procedure used to develop an equation showing how two variables are related.
Regression analysis Regression analysis involving one independent variable and one dependent variable is referred to as simple linear regression. Simple linear regression refers to the type of regression analysis for which the relationship between the independent variable and dependent variable are approximated by a(n) exponential curve. A(n) ________ refers to a measurable factor that defines a characteristic of a population, process, or system. Parameter In the simple linear regression model, the ________ accounts for the variability in the dependent variable that cannot be explained by the linear relationship between x and y . error term In the simple linear regression equation, the parameter B0 represents the _____ of the true regression line. y -intercept In the simple linear regression equation, the parameter B1 is the _______ of the true regression line. Slope Two variables have a positive linear correlation. As the dependent variable increases, the independent variable will increase. The procedure of using sample data to find the estimated regression equation is better known as the least squares method. A _____ is used to visualize sample data graphically and to draw preliminary conclusions about the possible relationship between the variables. scatter chart The difference between the observed value of the dependent variable and the value predicted using the estimated regression equation is known as the residual. The _____ is the range of values of the independent variables in the data used to estimate the regression model. experimental region
Prediction of the value of the dependent variable outside the experimental region is called extrapolation. Suppose an estimated regression equation has a coefficient of determination ( r 2) of 0.866. Interpret this value. The estimated regression equation explains approximately 86.6% of the variation in the dependent variable. The _____ is a measure of the error that results from using the estimated regression equation to predict the values of the dependent variable in a sample. sum of squares due to error (SSE) The coefficient of determination is defined as SSR/SST. What would be the coefficient of determination if the total sum of squares (SST) is 30 and the sum of squares due to regression (SSR) is 27?
- Winter '10
- Regression Analysis, Wyche Accounting