How does Excel represent internally the values we see on a spreadsheet? a) Some values are represented as numbers and others as letters and symbols. b) Each digit is represented as a specific alphanumeric code. c) All of the values, regardless of type, are represented as numbers. d) All of the values are represented according to their particular types. What is the symbol in Excel that indicates that what follows it is an expression? a) "" b) @ c) = d) -> Which of the following Excel functions will return the number of cells in a range by adding the values that match specified criteria? COUNTIF AVERAGEIF SUBTOTAL SUMIF
Added by Muscab R.
Step 1
Excel actually represents all values, regardless of type, as numbers. So the correct answer is c) All of the values, regardless of type, are represented as numbers. Show more…
Show all steps
Your feedback will help us improve your experience
Aparna Shakti and 95 other Probability educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Recommended Videos
IN EXCEL, SOLVE THIS PROBLEM USING EXCEL FUNCTIONS AND CALCULATIONS. SHOW STEPS. Consider the following time series data. (Use Excel for this problem. Copy and paste Excel Tables into your report for answering questions). Month 1 2 3 4 5 6 7 8 9 10 Value 12 19 24 13 20 23 15 21 23 18 Use the NaĂŻve Method of forecasting, prepare tables and calculate forecast accuracy measures. What is the forecast for month 11? Prepare the Time Series Plots. Use the "Historical Average Forecasting Method" that calculates "Forecast for a month" as "the average of all the observed data right from the beginning up until the previous month." Prepare tables and calculate forecast accuracy measures. What is the forecast for month 11? Prepare the Time Series Plots. Which method appears to provide the better forecast? Use different Measures of Forecast Accuracy in making this determination.
Sri K.
Review Excel help files (and other sources if you wish) and explain in your own words: The difference between the functions QUARTILE.INC() and QUARTILE.EXC(). Which of the two will you get if you use QUARTILE()? The difference between STDEV.P() and STDEV.S() and the difference between VAR.P() and VAR.S(). What is the Excel function COVARIANCE? (This has two forms: COVARIANCE.P() and COVARIANCE.S())? Can COVARIANCE be used to calculate the Coefficient of Variation of one sample (such as the sample in question 2)? If so, how? If not, how will you calculate the Coefficient of Variation of one sample using Excel?
Data Question Function(s) to Learn Answer How many data observations are present (sample size)? What is the sum of the data? What is the mean (average) of the data? What is the median of the data? What is the minimum value of the data? What is the maximum value of the data? COUNT SUM AVERAGE MEDIAN MIN MAX What is the square root of the sample size? What is the value of the third observation when squared? SQRT POWER What is the square root of the sample size rounded to two digits? ROUND What is the square root of the sample size rounded down to the next whole number? ROUNDDOWN What is the square root of the sample size rounded up to the next whole number? ROUNDUP What is the sample variance? What is the sample standard deviation? What is the sample variance rounded to two decimals? What is the sample standard deviation rounded to two decimals? VAR.S STDEV.S VAR.S and ROUND STDEV.S and ROUND How many observations are less than 75? Is the mean less than 75 (TRUE or FALSE)? COUNTIF
Lucas F.
Recommended Textbooks
Probability with Applications in Engineering, Science, and Technology
Probability and Statistics for Engineers and Scientists
Applied Statistics and Probability for Engineers
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD