MS Excel Quiz Questions 4

The post is about MS Excel Quiz Questions. It contains 20 multiple-choice questions covering the basics of MS Excel, filtering and sorting in MS Excel, Cell Reference, If condition, Hlookup, vlookup, xlookup, and text formatting. Let us start with the MS Excel Quiz Questions now.

Online MCQs about MS Excel quiz questions with Answers

1. What happens when one uses the median calculation but selects an even number of values in a range?

 
 
 
 

2. The IF function applies to one or two conditions, but what if one needs to apply multiple conditions?

 
 
 
 

3. After filtering a column and getting the results, in which two ways can you return to showing all the data in a column? Select two answers.

 
 
 
 

4. The difference between HLOOKUP, VLOOKUP, and XLOOKUP is how they look for data. How does each look for data?

 
 
 
 

5. What is the purpose of the IFS function in Excel?

 
 
 
 

6. What should you do if you have data in MS Excel that is in all upper-case letters and want to change it so the first letter of each word is capitalized?

 
 
 
 

7. What feature can you use to fix text that appears in mixed case?

 
 
 
 

8. If you have multiple filters set, how can you clear all of them at once?

 
 
 
 

9. In this HLOOKUP function, =HLOOKUP (B3, A2:B12,1), what does the number 1 indicate?

 
 
 
 

10. How to remove all empty rows at the same time in an imported spreadsheet?

 
 
 
 

11. Which statement best describes the purpose of filtering the data?

 
 
 
 

12. When you use nested functions, what is required for each of the functions?

 
 
 
 

13. How is a cell reference made as absolute in a formula?

 
 
 
 

14. What does VLOOKUP stand for?

 
 
 
 

15. There are two methods to locate and remove duplicated rows in Excel, what is the easiest way?

 
 
 
 

16. Which of the following formulas contains a mixed reference?

 
 
 
 

17. What is the first thing you should do when checking spelling errors in Excel?

 
 
 
 

18. After enabling Filtering, where can one see and access the filter controls?

 
 
 
 

19. What is one of the easiest common errors or inconsistencies to fix when importing data?

 
 
 
 

20. Formula errors in Excel are preceded by a hash symbol (#). What does it mean when multiple hash symbols exist in a cell?

 
 
 
 

Online MS Excel Quiz Questions with Answers

MS Excel Quiz Questions with Answers

  • What happens when one uses the median calculation but selects an even number of values in a range?
  • How is a cell reference made as absolute in a formula?
  • Formula errors in Excel are preceded by a hash symbol (#). What does it mean when multiple hash symbols exist in a cell?
  • What is one of the easiest common errors or inconsistencies to fix when importing data?
  • What is the first thing you should do when checking spelling errors in Excel?
  • What feature can you use to fix text that appears in mixed case?
  • How to remove all empty rows at the same time in an imported spreadsheet?
  • What does VLOOKUP stand for?
  • After enabling Filtering, where can one see and access the filter controls?
  • The IF function applies to one or two conditions, but what if one needs to apply multiple conditions?
  • The difference between HLOOKUP, VLOOKUP, and XLOOKUP is how they look for data. How does each look for data?
  • Which of the following formulas contains a mixed reference?
  • What is the purpose of the IFS function in Excel?
  • In this HLOOKUP function, =HLOOKUP (B3, A2:B12,1), what does the number 1 indicate?
  • If you have multiple filters set, how can you clear all of them at once?
  • There are two methods to locate and remove duplicated rows in Excel, what is the easiest way?
  • Which statement best describes the purpose of filtering the data?
  • When you use nested functions, what is required for each of the functions?
  • After filtering a column and getting the results, in which two ways can you return to showing all the data in a column? Select two answers.
  • What should you do if you have data in MS Excel that is in all upper-case letters and want to change it so the first letter of each word is capitalized?

Exploring Data Distribution in R Language

Online MCQs about Computer

Testing Population Proportion

Testing population proportion is a hypothesis testing procedure used to assess whether or not a sample from a population represents the true proportion of the entire population. Testing a sample population proportion is a widely used statistical method with various applications across different fields.

Purpose of Testing Population Proportion (one-sample)

The main purpose of testing a sample population proportion is to make inferences about an entire population based on the sample information. Testing a sample population proportion helps to determine whether an observed sample proportion is significantly different from a hypothesized population proportion.

Common Uses of Testing Population Proportion

The following are some common uses of population proportion:

  • Marketing research: To determine if a certain proportion of customers prefer one product compared to another.
  • Quality control: In manufacturing, population proportion tests can be used to test/check if the proportion of defective items in a production batch exceeds an acceptable threshold.
  • Medical research: To test the efficacy of a new treatment by comparing the proportion of patients who recover using the new treatment versus a standard treatment.
  • Political polling: To estimate the proportion of voters supporting a particular candidate or policy.
  • Social sciences: To examine the prevalence of certain behaviors or attitudes in a population.

Applications Population Proportion in Various Fields

  • Business: Testing customer satisfaction rates, conversion rates in A/B testing for websites, or employee retention rates.
  • Public health: Estimating vaccination rates, disease prevalence, or the effectiveness of public health campaigns.
  • Education: Assessing the proportion of students meeting certain academic standards or the effectiveness of new teaching methods.
  • Psychology: Evaluating the proportion of individuals exhibiting certain behaviors or responses in experiments.
  • Environmental science: Measuring the proportion of samples that exceed pollution thresholds.

Types of Testing Population Proportion

There are two types of population proportion tests.

  1. One-sample z-test for proportion: One-sample proportion tests are used when comparing a sample proportion to a known or hypothesized population proportion.
  2. Two-sample z-test for proportions: Two-sample proportion tests are used when comparing proportions from two independent samples.

Assumptions and Considerations

The following are assumptions and considerations when testing population proportion:

  • The sample should be randomly selected and representative of the population.
  • The sample size (number of observations in the sample) should be large enough (typically $np$ and $n(1-p)$ should both be greater than 5, where $n$ is the sample size and $p$ is the proportion).
  • For two-sample tests, the samples should be independent of each other.
  • Interpretation: The results of these tests are typically interpreted using p-values or confidence intervals, allowing researchers to make statistical inferences about the population based on the sample data.

Data Frive Decisions from Proportion Tests

By using tests for population proportions, researchers and professionals can make data-driven decisions, validate hypotheses, and gain insights into population characteristics across a wide range of fields and applications.

Suppose, a random sample is drawn and the population proportion (say) $\hat{p}$ is measured and $n\hat{p}\ge 5$, $n\hat{q}\ge5$, the distribution of $\hat{p}$ is approximately normal with $\mu_{\hat{p}} =p$ and $\sigma_{\hat{p}}=\sqrt{\frac{pq}{n}}$. Also, suppose that one of the possible null hypotheses of the following form, when testing a claim about a population proportion is:

$H_o: p=p_o$
$H_o:p\ge p_o$
$H_o\le p_o$

For simplicity, we will assume the null hypothesis $H_o:p=p_o$. The standardized test statistics for a one-sample proportion test is

\begin{align*}
Z&=\frac{\hat{p} – \mu_{\hat{p}}}{\sigma_{\hat{p}}}\\
&=\frac{\hat{p} -p_o }{\sqrt{\frac{p_oq_o}{n}}}
\end{align*}

This random variable will have a standard normal distribution. Therefore, the standard normal distribution will be used to compute critical values, regions of rejection, and p-values, as we use it to test a mean using a large sample.

Testing Population Proportion

Example 1 (Defective Items): Testing Population Proportion

A computer chip manufacturer tests microprocessors coming off the production line. In one sample of 577 processors, 37 were found to be defective. The company wants to claim that the proportion of defective processors is only 4%. Can the company claim be rejected at the $\alpha = 0.01$ level of significance?

Solution:

The null and alternative hypotheses for testing the one-sample population proportion will be

$H_o:p=0.04$
$H_1:p\ne 0.04$

By focusing on the alternative hypothesis symbol ($\ne$), the test is two-tailed with $p_o=0.04$.

The $\hat{p} = \frac{37}{577} \approx 0.064$.

the standardized test statistics is

\begin{align*}
Z &= \frac{\hat{p} – p_o}{\sqrt{\frac{p_oq_o}{n}}}\\
&=\frac{0.064 – 0.04}{\sqrt{\frac{(0.04)(0.96)}{577}}}\\
&=\frac{0.024}{0.008}\approx 3.0
\end{align*}

Looking up $Z=3.00$ in the standard normal table (area under the standard normal curve), we get a value of 0.9987. Therefore, $P(Z\ge 3.00) = 1-0.9987) = 0.0013$.
Note that the test is two-tailed, the p-value will be twice this amount or $0.0026$.

Since the p-value ($0.0026$) is less than the level of significance ($0.01$), that is $0.0025 < 0.01$ (p-value < level of significance), we will reject the company’s claim. It means that the proportion of defective processors is not 4%, it is either less than 4% or more than 4%.

Example 2 (Opinion Poll): Testing Population Proportion

An opinion poll of 1010 randomly chosen/selected adults finds that only 47% approve of the president’s job performance. The president’s political advisors want to know if this is sufficient data to show that less than half of adults approve of the president’s job performance using a 5% level of significance.

Solution:

The null and alternative hypothesis of the problem above will be

$H_o:p\ge 0.50$
$H_1:p< 0.50$

By focusing on the alternative hypothesis symbol (<), the test is left-tailed with $p_o=0.50$.

The $\hat{p} = 0.47$. The standardized test statistics for one-sample population proportion will be

\begin{align*}
Z &= \frac{\hat{p} – p_o}{\sqrt{\frac{p_oq_o}{n}}}\\
&=\frac{0.47 – 0.50}{\sqrt{\frac{(0.5)(0.5)}{1010}}}\\
&=\frac{-0.03}{0.01573}\approx -1.91
\end{align*}

For a left-tailed test (for $\alpha = 0.05$), the $Z_o=-1.645$. Since $-1.91 < -1.645$, the null hypothesis should be rejected. So the data does support the claim that $p<0.50$ at the $\alpha=0.05$ level of significance.

Performing Data Analysis in R Language

Intermediate First Year Mathematics Quiz

MCQs Data Analytics Questions 3

The Quiz is about Data Analytics Questions with Answers. There are 20 multiple-choice type questions related to “The Data Ecosystem and Languages for Data Professionals” covering the Languages related to the work of data professionals such as query languages, programming languages, and shell scripting. Let us start with the MCQs Data Analytics Questions Quiz now.

Please go to MCQs Data Analytics Questions 3 to view the test

MCQs Data Analytics Questions with Answers

Online MCQs Data Analytics Questions with Answers

  • Which of the following languages is one of the most popular querying languages today?
  • Which NoSQL database type stores each record and its associated data within a single document and also works well with Analytics platforms?
  • What type of data repository is used to isolate a subset of data for a particular business function, purpose, or community of users?
  • In use cases for RDBMS, what is one of the reasons that relational databases are so well suited for OLTP applications?
  • Structured Query Language, or SQL, is the standard querying language for what type of data repository?
  • In the data analyst’s ecosystem, languages are classified by type. What are shell and scripting languages most commonly used for?
  • Which of the following is an example of unstructured data?
  • Which of the data repositories serves as a pool of raw data and stores large amounts of structured, semi-structured, and unstructured data in their native formats?
  • SQL (Structured Query Language) was developed to work with relational database management systems (RDBMS).
  • What institute adopted SQL as a standard?
  • Which of the following is a data source that can be queried by an SQL statement?
  • What technical skills are mentioned as essential for Data Analysts?
  • Data Marts and Data Warehouses have typically been relational, but the emergence of what technology has helped to let these be used for non-relational data?
  • Which one of the NoSQL database types uses a graphical model to represent and store data, and is particularly useful for visualizing, analyzing, and finding connections between different pieces of data?
  • What is one of the most significant advantages of an RDBMS?
  • Web scraping is used to extract what type of data?
  • Which of the provided options offers simple commands to specify what is to be retrieved from a relational database?
  • When gathering data, you find agents keep their records and do not constantly update the information in the shared company database. In this case, the data would be considered ————–.
  • Document stores (also called document-oriented databases) store objects based on what?
  • OpenRefine is an open-source tool that allows you to:

MCQs Python Programming

https://itfeature.com