Microsoft Excel Quiz 3

The post is about the Microsoft Excel Quiz. There are 20 multiple-choice questions about Microsoft Excel which serves as a valuable resource for enhancing skills and preparing for exams such as MS-CIT, entrance exams, and university assessments. The Microsoft Excel Quiz encompasses both fundamental and advanced aspects of MS Excel to assist professionals and students alike. Let us start with the Microsoft Excel Quiz Now.

Online Microsoft Excel Quiz with Answers

1. What is one of the key components of a typical formula?

 
 
 
 

2. Which of the following key Data Analyst tasks is typically done last?

 
 
 
 

3. On the Excel Home tab, which of the following groups are listed?

 
 
 
 

4. When you open an Excel workbook or spreadsheet, what kind of file is it?

 
 
 
 

5. How can you zoom to a specific area of data in an Excel spreadsheet?

 
 
 
 

6. What tools or features can we use to split a single column with two names in it into two separate columns with a name in each?

 
 
 
 

7. Which of the following would be considered a core capability of spreadsheets?

 
 
 
 

8. How are Excel worksheet cells referenced?

 
 
 
 

9. What do custom filters provide that AutoFilters don’t?

 
 
 
 

10. Which of the following is a valid way of editing existing data in a cell?

 
 
 
 
 
 

11. When creating formulas, what is a mixed reference?

 
 
 
 

12. What is one of the functions found in the AutoSum drop-down list?

 
 
 
 

13. In Excel Desktop, what is one of the function categories on the Formulas tab in the Function Library group?

 
 
 
 

14. What character do you type first when you want to start writing a formula?

 
 
 
 

15. According to the video ‘Useful Functions for Data Analysis’, what is one of the most common functions a Data Analyst might use?

 
 
 
 

16. In Excel for the web, how can you format data in cells to use a currency?

 
 
 
 
 
 

17. Which of the following Excel keyboard shortcuts could be used to find how many rows of data you have in a worksheet, assuming you have no empty rows in your data?

 
 
 
 

18. What do you use the AutoFill feature for?

 
 
 
 

19. What are Excel cell references by default?

 
 
 
 

20. What is one of the ways to apply new data formats to the rest of a column?

 
 
 
 

Online Microsoft Excel Quiz with Answers

  • Which of the following would be considered a core capability of spreadsheets?
  • When you open an Excel workbook or spreadsheet, what kind of file is it?
  • On the Excel Home tab, which of the following groups are listed?
  • Which of the following key Data Analyst tasks is typically done last?
  • How are Excel worksheet cells referenced?
  • Which of the following Excel keyboard shortcuts could be used to find how many rows of data you have in a worksheet, assuming you have no empty rows in your data?
  • Which of the following is a valid way of editing existing data in a cell?
  • What is one of the key components of a typical formula?
  • In Excel for the web, how can you format data in cells to use a currency?
  • What are Excel cell references by default?
  • When creating formulas, what is a mixed reference?
  • How can you zoom to a specific area of data in an Excel spreadsheet?
  • What do you use the AutoFill feature for?
  • What character do you type first when you want to start writing a formula?
  • What is one of the functions found in the AutoSum drop-down list?
  • In Excel Desktop, what is one of the function categories on the Formulas tab in the Function Library group?
  • What is one of the ways to apply new data formats to the rest of a column?
  • What tools or features can we use to split a single column with two names in it into two separate columns with a name in each?
  • What do custom filters provide that AutoFilters don’t?
  • According to the video ‘Useful Functions for Data Analysis’, what is one of the most common functions a Data Analyst might use?
Microsoft Excel Quiz with Answers

Data Structure in R Language

General Knowledge Quiz

Types of Hypothesis Tests in Statistics

Introduction to Types of Hypothesis Tests

In statistics, hypothesis tests are methods used to make inferences or draw conclusions about a population based on sample data. In this pose, we will discuss the Basic Types of Hypothesis Tests in Statistics. There are three basic types of hypothesis tests, namely (i) Left-Tailed Test, (ii) Right-Tailed Test, and (iii) Two-Tailed Test.

Note that I am not talking about Statistical tools used under specific conditions related to the data type and distribution. I am talking about the nature of the hypotheses being tested. Therefore, I will focus in this post on the area under the curve in the tails. In hypothesis testing, the distribution of the test’s rejection region can be characterized as either one-tailed or two-tailed. The one-tailed tests include both left- and right-tailed tests.

Hypothesis-Testing-Tails-Critical-Region

Left-Tailed Test

The left-tailed tests are used when the null hypothesis is being tested in a claim that the population parameter at least ($\ge$) a given value. Note that the alternative hypothesis then claims that the parameter is less than (<) the value. For example,

A tire manufacturer claims that their tires last on average more than 35000 miles. If one thinks that the claim is false, then one would write the claim as $H_o$, remembering to include the condition of equality. The hypothesis for this test would be: 
$$H_o:\mu\ge 35000$$
$$H_1: \mu<35000$$

One would hope that the sample data would allow the rejection of the null hypothesis, refuting the company’s claim.

The $H_o$ will be rejected in the case above if the sample mean is statistically significantly less than 35000. That is, if the sample mean is in the left-tail of the distribution of all sample means.

Right Tailed Test

The right-tailed test is used when the null hypothesis ($H_0$) being tested is a claim that the population parameter is at most ($\le$) a given value. Note that the alternative hypothesis ($H_1$) then claims that the parameter is greater than (>) the value.

Suppose, you worked for the tire company and wanted to gather evidence to support their claim then you will make the company's claim $H_1$ and remember that equality will not be included in the claim (H_o$). The hypothesis test will be

$$H_0:\mu \le 35000$$
$$H_1:\mu > 35000$$

If the sample data was able to support the rejection of $H_o$ this would be strong evidence to support the claim $H_1$ which is what the company believes to be true.

One should reject $H_o$ in this case if the sample mean was significantly more than 35000. That is, if the sample mean is in the right-tailed of the distribution of all sample means.

Two-Tailed Test

The two-tailed test is used when the null hypothesis ($H_o$ begins tested as a claim that the population parameter is equal to (=) a given value. Note that the alternative hypothesis ($H_1$) then claims that the parameter is not equal to ($\ne$) the value. For example, the Census Bureau claims that the percentage of Punjab’s area residents with a bachelor’s degree or higher is 24.4%. One may write the null and alternative hypotheses for this claim as:

$$H_o: P = 0.244$$
$$H_1: P \ne 0.244$$

In this case, one may reject $H_o$ if the sample percentage is either significantly more than 24.4% or significantly less than 24.4%. That is if the sample proportion was in either tail (both tails) of the distribution of all sample proportions.

Key Differences

  • Directionality: One-tailed tests look for evidence of an effect in one specific direction, while two-tailed tests consider effects in both directions.
  • Rejection Regions: In a one-tailed test, all of the rejection regions are in one tail of the distribution; in a two-tailed test, the rejection region is split between both tails.
Statistics and Data Analysis Types of Hypothesis Tests in Statistics

Online Quiz and Test Website

R Programming Language and Frequently Asked Questions

MCQs on Statistical Inference 9

The quiz is about MCQs on Statistical Inference with Answers. The quiz contains 20 questions about hypothesis testing and p-values. It covers the topics of formulation of the null and alternative hypotheses, level of significance, test statistics, region of rejection, and decision about acceptance and rejection of the hypothesis. Let us start with the Quiz MCQs on Statistical Inference.

Please go to MCQs on Statistical Inference 9 to view the test

MCQs on Statistical Inference with Answers

  • A Type-I error is ————–, and the Type-I error rate is determined by ————–.
  • Suppose a research article indicates a $p = 0.30$ value in the results section ($\alpha = 0.05$). You have found the probability of the null hypothesis being true ($p = 0.30$).
  • Suppose a research article indicates a $p = 0.30$ value in the results section ($\alpha = 0.05$). You have proven the null hypothesis (that is, you have proven that there is no difference between the population means).
  • Suppose that a research article indicates a value of $p = 0.001$ in the results section ($\alpha = 0.05$). The null hypothesis has been shown to be false.
  • Suppose a research article indicates a $p = 0.30$ value in the results section ($\alpha = 0.05$). The p-value gives the probability of obtaining a significant result whenever a given experiment is replicated.
  • Suppose a research article indicates a value of $p = 0.30$ in the results section ($\alpha = 0.05$). Obtaining a statistically non-significant result implies that the effect detected is unimportant.
  • Suppose a research article indicates a value of $p = 0.001$ in the results section ($\alpha = 0.05$). The p-value of a statistical test is the probability of the observed result or a more extreme result, assuming the null hypothesis is true.
  • Suppose a research article indicates a $p = 0.001$ value in the results section ($\alpha = 0.05$). Obtaining a statistically significant result implies that the effect detected is important.
  • Suppose a research article indicates a $p = 0.001$ value in the results section ($\alpha = 0.05$). You have absolutely proven your alternative hypothesis (that is, you have proven that there is a difference between the population means).
  • Suppose a research article indicates a value of $p = 0.001$ in the results section ($\alpha = 0.05$). You have found the probability of the null hypothesis being true ($p = .001$).
  • Suppose a research article indicates a $p = 0.001$ value in the results section ($\alpha = 0.05$). The probability that the results of the given study are replicable is not equal to $1-p$.
  • Person A is very skeptical about homeopathy. Person B believes strongly in homeopathy. They both read a study about homeopathy, which reports a positive effect and $p < 0.05$. Person A would be more likely than Person B to conclude that ———-, and Person B would be more likely than Person A to think that ————-.
  • You perform two studies to test a potentially life-saving drug. Both studies have 80% power. What is the chance of two type 2 errors (of false negatives) in a row?
  • Study A and B are completely identical, except that all tests reported in Study A were pre-registered at a publicly available location (and the reported tests match the pre-registered tests), but all tests in Study B are not pre-registered. Both contain analyses with covariates. Based on research on flexibility in the data analysis, we can expect that on average study A will have ————; the covariate analyses are ————-.
  • When the null hypothesis is true, the probability of finding a specific p-value is ————-.
  • After finding a single statistically significant p-value we can conclude that ————-, but it would be incorrect to conclude that ————.
  • When $H_0$ is true, the probability that at least 1 out of a $X$ completely independent findings is a Type 1 error is equal to ————, this probability ———— when you look at your data and collect more data if a test is not significant.
  • It is important to have access to all (and not just statistically significant) research findings to be able to ————. A consequence of publication bias is that ———–.
  • When the difference between means is 5, and the standard deviation is 4, Cohen’s d is ————— which is ————— according to the benchmarks proposed by Cohen.
  • Suppose a research article indicates a $p = 0.30$ value in the results section ($\alpha = 0.05$). The alternative hypothesis has been shown to be false.
MCQs on Statistical Inference

Online MCQs and Test Website, gmstat.com

R Programming Language and Statistics