QBA Final Exam Study Guide questions with correct answers, Exams of Computer Science

Download QBA Final Exam Study Guide questions with correct answers and more Exams Computer Science in PDF only on Docsity!

QBA Final Exam Study Guide questions

with correct answers

Why should we take the time to format spreadsheets? - ** VERIFIED ANSWERS **✔✔-It helps communicate the data more clearly -It makes the work look more professional What is used to draw attention to headings and distinguish them from the data in tables? - ** VERIFIED ANSWERS **✔✔Contrast What is the difference between a formula and a function? - ** VERIFIED ANSWERS **✔✔A function is a built-in formula How do you know how to format a spreadsheet in the "real world"? - ** VERIFIED ANSWERS **✔✔You'll need to create or conform to the specific standards for an individual company or industry What is syntax? - ** VERIFIED ANSWERS **✔✔The prompts Excel gives you regarding what inputs to use in a function If you create a formula in this tab that refers to a cell in the 1 Formatting tab, how would that tab name appear in the formula? - ** VERIFIED ANSWERS **✔✔'' Formatting!' The syntax for the SUM function looks like this: SUM(number1, [number2],...) What is this syntax telling you to do? - ** VERIFIED ANSWERS **✔✔Select all cells you want to add together, separate each with a comma, and close with a parenthesis How is the ROUND function different from using the decrease decimal button? - ** VERIFIED ANSWERS **✔✔The round function actually removes extra digits; the decrease button only hides extra decimal places from view

What type of data are the Sales amounts in the Paste Special tab, and why are they considered that type? - ** VERIFIED ANSWERS **✔✔Quantitative, because they are measurable, numeric values What portion of this formula should be calculated first? Y = (X + CD) + D^2 * X + C - ** VERIFIED ANSWERS **✔✔X + CD Which of the following is an example of qualitative data? - ** VERIFIED ANSWERS **✔✔Major What is the purpose of creating an absolute reference to a cell in a formula? - ** VERIFIED ANSWERS **✔✔To ensure when your formula is copied that the value in the same exact cell is used for each copied formula In the syntax =(AVERAGEIFS(average_range, criteria_range1, criteria1,...), what is the average_range? - ** VERIFIED ANSWERS **✔✔The selected range of cells that will have its values averaged What is the standard deviation of a data set? - ** VERIFIED ANSWERS **✔✔The average difference from the data points to the mean In a standard normal distribution, what is 1 equal to? - ** VERIFIED ANSWERS **✔✔The standard deviation When you want to fairly compare two values from different distributions, what should you use? - ** VERIFIED ANSWERS **✔✔Their z-scores What does a Z-score of 2.02 mean? - ** VERIFIED ANSWERS **✔✔The value is above the mean In the scenario above, what is the population mean of 60? - ** VERIFIED ANSWERS **✔✔Population Parameter

What tells you the average difference between the predicted Y value and the actual Y value? - ** VERIFIED ANSWERS **✔✔Standard Error What does the value of the slope in the regression equation tell you? - ** VERIFIED ANSWERS **✔✔The change in Y if X changes by 1 unit In the Regression Equation, what is the Y-intercept? - ** VERIFIED ANSWERS **✔✔The value of Y when X is 0 What is the purpose of the Regression Equation? - ** VERIFIED ANSWERS **✔✔Allows you to predict Y values based on known X values What P (probability) value tells us the relationship is significant? - ** VERIFIED ANSWERS **✔✔<=. Linear relationships can be... - ** VERIFIED ANSWERS **✔✔Either positive or negative What is the purpose of simple linear regression? - ** VERIFIED ANSWERS **✔✔To predict one variable based on a known variable and correlation If the correlation coefficient between 2 variables is -0.89, what is the strength of the correlation? - ** VERIFIED ANSWERS **✔✔Very strong negative correlation Pearson's Correlation is used to analyze the relationship between what kind of variables? - ** VERIFIED ANSWERS **✔✔Quantitative What is correlation? - ** VERIFIED ANSWERS **✔✔How much the change in 1 variable is related to a change in another variable What does it mean when we say that the tails of the normal curve are asymptotic to the x axis? - ** VERIFIED ANSWERS **✔✔The tails get closer and closer to the x axis but never touch it.

What are the parameters of the standard normal distribution? - ** VERIFIED ANSWERS **✔✔Mean = 0, Standard Deviation = 1 What does the symbol μ represent? - ** VERIFIED ANSWERS **✔✔Population mean What does the symbol s2 represent? - ** VERIFIED ANSWERS **✔✔Sample Variance What is the correct interpretation of the variance? - ** VERIFIED ANSWERS **✔✔On average, what a consumer is willing to pay differs from the mean of $15 by 25 squared dollars. What is the correct interpretation of the standard deviation? - ** VERIFIED ANSWERS **✔✔On average, what a consumer is willing to pay differs from the mean of $15 by $5. The mean of $15 is a __________________. - ** VERIFIED ANSWERS **✔✔Sample statistic What is the population? - ** VERIFIED ANSWERS **✔✔All consumers What is the sample? - ** VERIFIED ANSWERS **✔✔100 consumers The United States government conducts a census every 10 years. They collect information from every single household in America to determine the population of the country. During the last census, they found that 14.5% of the country is 65 years or older. - ** VERIFIED ANSWERS **✔✔population parameter. The 28.56% - ** VERIFIED ANSWERS **✔✔sample statistic. What is the population? - ** VERIFIED ANSWERS **✔✔All Ohio customer

Amazon wants to determine if how many of their Ohio customers are part of the 'Subscribe & Save' program. They take a sample of 15 customers from each zip code in Ohio (for a total of 11,890 customers). They find that 28.56% of those customers have received a 'Subscribe & Save' delivery in the past 3 months. - ** VERIFIED ANSWERS **✔✔11,890 customers What does the symbol σ represent? - ** VERIFIED ANSWERS **✔✔Population standard deviation Which of the following is NOT a characteristic of the normal distribution? - ** VERIFIED ANSWERS **✔✔It refers to sample data Based on the empirical rule ________ percent of the observations will be contained within 1 standard deviations around the arithmetic mean, ________ percent of the observations will be contained within 2 standard deviations around the arithmetic mean, and ________ percent of the observations will be contained within 3 standard deviations around the arithmetic mean. - ** VERIFIED ANSWERS **✔✔about 68, about 95, and about 99 What is the correct interpretation of the variance? - ** VERIFIED ANSWERS **✔✔It represents the average difference from a data point to the mean, in squared units. What is the correct interpretation of the standard deviation? - ** VERIFIED ANSWERS **✔✔It represents the average difference from a data point to the mean. "33.2%" is a - ** VERIFIED ANSWERS **✔✔sample statistic Of the U.S. adult population, 36% has an allergy. A sample of 1200 randomly selected adults resulted in 33.2% reporting an allergy. - ** VERIFIED ANSWERS **✔✔population parameter Which set of values has no specific relationship with each other? - ** VERIFIED ANSWERS **✔✔Mode and Sum

Why is the standard deviation a better measure of spread than range? - ** VERIFIED ANSWERS **✔✔Standard deviation can predict the percentage of values that fall in a given interval In this data, what central tendency amount would be best to report? - ** VERIFIED ANSWERS **✔✔Mean On average, how much does each rental's rating differ from the mean? - ** VERIFIED ANSWERS **✔✔0. In this analysis, the mean and median are the same. What does this indicate? - ** VERIFIED ANSWERS **✔✔The data is normally distributed Why aren't the column headings included in the first array of the index command? - ** VERIFIED ANSWERS **✔✔Because the data we're looking for is not in the column headings In a copyable Index Match Match command, all values are locked except: - ** VERIFIED ANSWERS **✔✔The row of the first lookup value and the column of the second lookup value What is the single value returned by the INDEX function? - ** VERIFIED ANSWERS **✔✔The value of a cell What is the single value returned by the MATCH function? - ** VERIFIED ANSWERS **✔✔It could be a row number or a column number in the lookup table What function would you use to see if multiple conditions are true? - ** VERIFIED ANSWERS **✔✔IF AND When does the IFS command display a value? - ** VERIFIED ANSWERS **✔✔When it reaches the first true condition

How many arguments (inputs) does this syntax REQUIRE? - ** VERIFIED ANSWERS **✔✔One What type of data are the "Owner IDs" in the table above? - ** VERIFIED ANSWERS **✔✔Qualitative Why is SUM(A1:F1) better than SUM(A1,B1,C1,D1,E1,F1)? - ** VERIFIED ANSWERS **✔✔-Less error prone -Less work Why are absolute references necessary? - ** VERIFIED ANSWERS **✔✔To ensure certain references to cells remain constant when copying formulas What is the most important element in a chart? - ** VERIFIED ANSWERS **✔✔The data; it doesn't matter how the chart looks if the content is inaccurate or incomplete What is true about plotting a partial dataset in a chart? - ** VERIFIED ANSWERS **✔✔Partial data sets may be out of context, potentially skewing the interpretation of the data You want to see if there is a relationship between two sets of data. What type of chart should you use? - ** VERIFIED ANSWERS **✔✔Scatterplot When do you use a bar chart over a column chart? - ** VERIFIED ANSWERS **✔✔Use a bar chart if the category labels have to be rotated in a column chart You want to show a series of monthly sales for 3 stores over the last two years. What type of chart should you use? - ** VERIFIED ANSWERS **✔✔Line chart You want to show the percentages that 4 different categories make up of a total amount. What chart type should you use? - ** VERIFIED ANSWERS **✔✔Pie chart

You want to compare the total sales for 9 different salespeople. What chart type should you use? - ** VERIFIED ANSWERS **✔✔A bar/column chart What should be avoided in charts as a best practice? - ** VERIFIED ANSWERS **✔✔Both 3D and purely decorative elements should be avoided What should be included in charts as a best practice? - ** VERIFIED ANSWERS **✔✔Titles and the source What type of data can be plotted in a chart? - ** VERIFIED ANSWERS **✔✔Both quantitative and qualitative If you want to show the total sales for each employee in a pivot table, what categories would you use for the rows and values, respectively? - ** VERIFIED ANSWERS **✔✔Employee for row; Sales for values Are pivot tables updatable? - ** VERIFIED ANSWERS **✔✔Yes, but not automatically; the "refresh" button must be pushed to sync with updated data What is the purpose of a pivot table? - ** VERIFIED ANSWERS **✔✔To summarize data What function would you choose to answer, "Find the number of employees that work full-time." - ** VERIFIED ANSWERS **✔✔COUNTIFS Assume you have data for sales generated by all employees in a company. In which scenario would you choose to use a regular SUM function rather than a SUMIFS function? - ** VERIFIED ANSWERS **✔✔Find the total sales for all employees How are COUNTIFS different from SUMIFS and AVERAGEIFS? - ** VERIFIED ANSWERS **✔✔SUMIFS and AVERAGEIFS have one more required argument in the syntax

What is the purpose of AVERAGEIFS? - ** VERIFIED ANSWERS **✔✔To average the value of selected cells when specific conditions are met What is the purpose of SUMIFS? - ** VERIFIED ANSWERS **✔✔To total the value of selected cells when specific conditions are met Why do we use "IFS" instead of the "IF" versions of the functions in Excel? - ** VERIFIED ANSWERS **✔✔"IFS" statements allow you to add additional conditions, if needed What does the CountIF syntax tell you to select for the inputs? =COUNTIFS (Criteria_range1, criteria1, ...) - ** VERIFIED ANSWERS **✔✔Cells to look in, value(s) to look for Which of the following is NOT a type of descriptive statistic? - ** VERIFIED ANSWERS **✔✔Index Match Match If you think that your dataset will change or be updated, what is the best way to compute descriptive statistics? - ** VERIFIED ANSWERS **✔✔Use functions (e.g., =AVERAGE, =MEDIAN) What does a COUNTIFS function show you? - ** VERIFIED ANSWERS **✔✔The number of times a specified value appears in a range of selected cells If you have qualitative data, which of the following is appropriate to report? - ** VERIFIED ANSWERS **✔✔Mode How do Mean and Median differ? - ** VERIFIED ANSWERS **✔✔The mean is influenced by outliers but the median is not. What is true about the standard deviation? - ** VERIFIED ANSWERS **✔✔mean

If the mean and median are similar, which should be used and why? - ** VERIFIED ANSWERS **✔✔The mean because that is what you should report if you have a normal distribution. You want to find the 4th lowest value in a range of cells. What function would be best?

• ** VERIFIED ANSWERS **✔✔Small You want to find the highest value in a range of cells. What function should you use? - ** VERIFIED ANSWERS **✔✔Max We always include the [match_type] argument in a Match function, even though it is optional. Why? - ** VERIFIED ANSWERS **✔✔We need an exact match In function syntax, what do square brackets mean? Ex: = SUM(number1, [number2],...) Ex: = MATCH(lookup_value, lookup_array, [match_type]) what do the square brackets mean? - ** VERIFIED ANSWERS **✔✔That portion of the function is optional In the Index function syntax. = Index (array, row_number, col_number) what does "array" mean? - ** VERIFIED ANSWERS **✔✔All of the data cells in the table What is the output of a match function? - ** VERIFIED ANSWERS **✔✔The value in a certain cell What is the first car name in your sorted Cars Source table? - ** VERIFIED ANSWERS **✔✔BMW i What is the first name of the mentor in the top row of your completed Mentor table? - ** VERIFIED ANSWERS **✔✔Shirly What type of data are the Mentee IDs? - ** VERIFIED ANSWERS **✔✔Qualitative

What type of data are the ranges in the Electric Cars data? - ** VERIFIED ANSWERS **✔✔Quantitative What is the purpose of the Index function in the Index (Match, Match) function? - ** VERIFIED ANSWERS **✔✔To find the value of the cell where the row and column numbers intersect What is the purpose of the match functions in the Index (Match, Match) function? - ** VERIFIED ANSWERS **✔✔To find the row and column numbers Employees whose sales exceeded $5000 receive a bonus of $250. Employees whose sales are $3001 -$5000 get a bonus of $100. Employees whose sales are $1000- get a bonus of $50. What is the correct syntax? - ** VERIFIED ANSWERS **✔✔IFS(F4>5000, 250, F4>3000, 100, F4>1000, 50) What is the best way to binary encode Male as the number one and female as the number zero? - ** VERIFIED ANSWERS **✔✔IF ( A3="Male", 1, 0 ) Given this syntax: IF(Logical_Test, Value_If_True, Value_If_False) what would be an example of a "Logical_Test" - ** VERIFIED ANSWERS **✔✔C4 <= B What is the purpose of binary encoding? - ** VERIFIED ANSWERS **✔✔To turn qualitative data into values that can be analyzed using advanced statistical analysis What would the output be if the logical test in the following statement was false? =IF(C4>50, "Blue", "Red") - ** VERIFIED ANSWERS **✔✔Red What would the output be if the logical test in the following statement was true? =IF(C4>50, "Nailed It!", "Doh!") - ** VERIFIED ANSWERS **✔✔Nailed It! You have a table of students' genders and exam grades. In which scenario would you use an "IF(AND)" function? - ** VERIFIED ANSWERS **✔✔Find the female students who earned at least a 75% on their exam

If you wanted to lock your reference to cell D7 in a formula and copy that formula down a column, what should it look like? - ** VERIFIED ANSWERS **✔✔D$ If you wanted to lock your reference to cell D2 in a formula and copy that formula across a row, what should it look like? - ** VERIFIED ANSWERS **✔✔$D Can you use a mixture of absolute and relative references in a single formula? - ** VERIFIED ANSWERS **✔✔Yes