Quiz: Excel Regression
Main.ExcelQuiz4 History
Hide minor edits - Show changes to output
Added lines 1-118:
(: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?
->'''A.''' Comma Delimited
-->(:toggle hide q1a button show="Select":)
(:div id=q1a:)
-->%blue%Correct.%% Excel uses the comma to separate data rows into individual cells.
(:divend:)
->'''B.''' Fixed Width
-->(:toggle hide q1b button show="Select":)
(:div id=q1b:)
-->%red%Incorrect.%% The data is separated by commas, not necessarily fixed width in spacing.
(:divend:)
->'''C.''' Tab Delimited
-->(:toggle hide q1c button show="Select":)
(:div id=q1c:)
-->%red%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.
->'''A.''' Tab
-->(:toggle hide q2a button show="Select":)
(:div id=q2a:)
-->%blue%Correct.%%
(:divend:)
->'''B.''' Semi-colon
-->(:toggle hide q2b button show="Select":)
(:div id=q2b:)
-->%blue%Correct.%%
(:divend:)
->'''C.''' Comma
-->(:toggle hide q2c button show="Select":)
(:div id=q2c:)
-->%blue%Correct.%%
(:divend:)
->'''D.''' Space
-->(:toggle hide q2d button show="Select":)
(:div id=q2d:)
-->%blue%Correct.%%
(:divend:)
->'''E.''' Any character or phrase as indicated by "Other:"
-->(:toggle hide q2e button show="Select":)
(:div id=q2e:)
-->%blue%Correct.%%
(:divend:)
----
'''3.''' What option do you select from an Excel scatter plot to add a linear or polynomial correlation to a data series?
->'''A.''' Add Data Labels
-->(:toggle hide q3a button show="Select":)
(:div id=q3a:)
-->%red%Incorrect.%% Add trendline to create a linear or polynomial fit.
(:divend:)
->'''B.''' Add Trendline
-->(:toggle hide q3b button show="Select":)
(:div id=q3b:)
-->%blue%Correct.%%
(:divend:)
->'''C.''' Format Data Series
-->(:toggle hide q3c button show="Select":)
(:div id=q3c:)
-->%red%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?
->'''A.''' Minimize the sum of (y predicted - y measured)
-->(:toggle hide q4a button show="Select":)
(:div id=q4a:)
-->%red%Incorrect.%% Either use the absolute value of the error or squared error.
(:divend:)
->'''B.''' Minimize the sum of (y predicted - y measured)^2
-->(:toggle hide q4b button show="Select":)
(:div id=q4b:)
-->%blue%Correct.%% Minimize the sum of squared errors or sum of absolute error.
(:divend:)
->'''C.''' Require that the sum of (y predicted - y measured)^2 = 0
-->(:toggle hide q4c button show="Select":)
(:div id=q4c:)
-->%red%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:)
(: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?
->'''A.''' Comma Delimited
-->(:toggle hide q1a button show="Select":)
(:div id=q1a:)
-->%blue%Correct.%% Excel uses the comma to separate data rows into individual cells.
(:divend:)
->'''B.''' Fixed Width
-->(:toggle hide q1b button show="Select":)
(:div id=q1b:)
-->%red%Incorrect.%% The data is separated by commas, not necessarily fixed width in spacing.
(:divend:)
->'''C.''' Tab Delimited
-->(:toggle hide q1c button show="Select":)
(:div id=q1c:)
-->%red%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.
->'''A.''' Tab
-->(:toggle hide q2a button show="Select":)
(:div id=q2a:)
-->%blue%Correct.%%
(:divend:)
->'''B.''' Semi-colon
-->(:toggle hide q2b button show="Select":)
(:div id=q2b:)
-->%blue%Correct.%%
(:divend:)
->'''C.''' Comma
-->(:toggle hide q2c button show="Select":)
(:div id=q2c:)
-->%blue%Correct.%%
(:divend:)
->'''D.''' Space
-->(:toggle hide q2d button show="Select":)
(:div id=q2d:)
-->%blue%Correct.%%
(:divend:)
->'''E.''' Any character or phrase as indicated by "Other:"
-->(:toggle hide q2e button show="Select":)
(:div id=q2e:)
-->%blue%Correct.%%
(:divend:)
----
'''3.''' What option do you select from an Excel scatter plot to add a linear or polynomial correlation to a data series?
->'''A.''' Add Data Labels
-->(:toggle hide q3a button show="Select":)
(:div id=q3a:)
-->%red%Incorrect.%% Add trendline to create a linear or polynomial fit.
(:divend:)
->'''B.''' Add Trendline
-->(:toggle hide q3b button show="Select":)
(:div id=q3b:)
-->%blue%Correct.%%
(:divend:)
->'''C.''' Format Data Series
-->(:toggle hide q3c button show="Select":)
(:div id=q3c:)
-->%red%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?
->'''A.''' Minimize the sum of (y predicted - y measured)
-->(:toggle hide q4a button show="Select":)
(:div id=q4a:)
-->%red%Incorrect.%% Either use the absolute value of the error or squared error.
(:divend:)
->'''B.''' Minimize the sum of (y predicted - y measured)^2
-->(:toggle hide q4b button show="Select":)
(:div id=q4b:)
-->%blue%Correct.%% Minimize the sum of squared errors or sum of absolute error.
(:divend:)
->'''C.''' Require that the sum of (y predicted - y measured)^2 = 0
-->(:toggle hide q4c button show="Select":)
(:div id=q4c:)
-->%red%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:)
