Quiz: Excel Regression
Main.ExcelQuiz4 History
Hide minor edits - Show changes to markup
(:title Quiz: Excel Regression:) (:keywords quiz, test, Excel, regression, variable, expression, introduction, course:) (:description Learning assessment on Excel data import and regression.:)
1. When importing a text file into Excel, there are two options: Delimited or Fixed Width to indicate how the columns of data are separated. In the case of a text file with data separated by commas, which option would you likely select?
(:div id=q1a:)
- Correct. Excel uses the comma to separate data rows into individual cells.
(:divend:)
(:div id=q1b:)
- Incorrect. The data is separated by commas, not necessarily fixed width in spacing.
(:divend:)
(:div id=q1c:)
- Incorrect. Tab delimited is also a common way to separate data. However, commas are used in this data import.
(:divend:)
2. What are some of the possible delimiters for parsing a data text file into Excel? Select all that apply.
(:div id=q2a:)
- Correct.
(:divend:)
(:div id=q2b:)
- Correct.
(:divend:)
(:div id=q2c:)
- Correct.
(:divend:)
(:div id=q2d:)
- Correct.
(:divend:)
(:div id=q2e:)
- Correct.
(:divend:)
3. What option do you select from an Excel scatter plot to add a linear or polynomial correlation to a data series?
(:div id=q3a:)
- Incorrect. Add trendline to create a linear or polynomial fit.
(:divend:)
(:div id=q3b:)
- Correct.
(:divend:)
(:div id=q3c:)
- Incorrect. Add trendline to create a linear or polynomial fit.
(:divend:)
4. What is a possible objective function for nonlinear regression when the model cannot fit the data perfectly?
(:div id=q4a:)
- Incorrect. Either use the absolute value of the error or squared error.
(:divend:)
(:div id=q4b:)
- Correct. Minimize the sum of squared errors or sum of absolute error.
(:divend:)
(:div id=q4c:)
- Incorrect. It is likely not be possible to find a solution that makes the error exactly equal to zero. It is best to minimize the error and it may find a zero solution, if possible.
(:divend:)