Question

In: Computer Science

please provide example(s) how you have used excel to analyze data and share your results?? this...

please provide example(s) how you have used excel to analyze data and share your results??
this is more like a inteview question but i want to nniw its sample answer

Solutions

Expert Solution

Answer : Basically the excel is used to organised the data into a cellular form. It is largely used in data analysis.

There are some features which has been provided in Excel -

1) Sort - You can sort your data i ascending or descending order on one column or multiple column.

2) Filter - You can filter you data in excel as per your criteria.

3) Charts - A simple excel chart can say more than a sheet full of numbers. Creating chart is very easy.

4) Tables - It allow you to analyze your data in excel quickly and easily.

5) Conditional Formatting - It enables you to highlight cells with a certain colors.

Lets take an example : Suppose we need to organised a student details in excel then we use some of the column as shown in image and colored their as per their importance.

Here i highlighted the column name by the color because they are the titles. By using this excel , we can analyse or organised the data of student.


Related Solutions

1. Explain Utilitarianism and provide an example of how Utilitarianism might be used to analyze a...
1. Explain Utilitarianism and provide an example of how Utilitarianism might be used to analyze a decision. 2. Summarize the Deontologic Theory of Ethics. Is this theory workable in our society? Why or why not? 3. Briefly explain Virtue Ethics. Explain how it might be used to guide decisions.
Please share an example of how differences in shared meaning have affected you.
Please share an example of how differences in shared meaning have affected you.
Please explain your answers and use Excel to show the excel formula you used to get...
Please explain your answers and use Excel to show the excel formula you used to get your solution. 6. A manufacturing process produces connecting rods whose diameter is normally distributed with mean 1.495 cm and standard deviation .05 cm. In what range will the “middle 80%” of the diameters lie? What about the “middle 98%”?
Show your numerical answer(s) and the Excel function(s) and inputs you used to get the answer.  You...
Show your numerical answer(s) and the Excel function(s) and inputs you used to get the answer.  You may use up to 25 words (50 for #4) to supplement your numbers, tables and Excel functions. 1. State Retirement Funding (5 points – 1 page with table, functions and 25 words) A state retirement plan has been frozen.  It is considered fully-funded, with $635,244,352.26 of assets on hand and makes payouts to 1,000 recipients.  It assumes it will earn 7.5% per year on these assets.  The...
1) (note: Please also provide the excel formulas used to solve it )  You work for a...
1) (note: Please also provide the excel formulas used to solve it )  You work for a soft-drink company in the quality control division. You are interested in the standard deviation of one of your production lines as a measure of consistency. The product is intended to have a mean of 12 ounces, and your team would like the standard deviation to be as low as possible. You gather a random sample of 18 containers. Estimate the population standard deviation at...
Please provide an example and then discuss how regression analysis may be used as a forecasting...
Please provide an example and then discuss how regression analysis may be used as a forecasting tool. Thank you.
How do you Use and interpret one-way analysis of variance (ANOVA)? Please provide example(s) in a...
How do you Use and interpret one-way analysis of variance (ANOVA)? Please provide example(s) in a research setting, i just want to have an overview on what a one way analysis of variance is and how it is applied in an experiment. eg how do i know to use anova in an experiment?
Please provide a real world example of of how GDP is used to calculate economic growth...
Please provide a real world example of of how GDP is used to calculate economic growth in the United States.
Please provide references: Analyze the measures your state (Georgia) and local community have in place to...
Please provide references: Analyze the measures your state (Georgia) and local community have in place to prepare hospitals for two (2) different types of threats to public health. Does the design of these measures of threats allow for the sufficient protection of the population in the face of an imminent threat. Justify your response. Examine two to three (2-3) changes to the preparedness policies of your chosen state (Georgia) and federal government agencies. Determine the significant social, political, or environmental...
How would you enforce least privilege and SoD controls in your system? Please provide an example.
How would you enforce least privilege and SoD controls in your system? Please provide an example.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT