Create a formula to solve the scenario

Assignment Help Other Subject
Reference no: EM131565670

Assignment: Data Analysis With Spreadsheets With Lab Course Number: BIS155

1. Pick a function in Excel and discuss how that function is used to calculate results in your worksheets. Using the following scenarios, discuss how you would apply the Excel functions or create a formula to solve the scenario. Be specific!

o You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost.

o You wish to calculate the total pay for an employee who receives regular time for 40 hours, time and a half for 40-50 hours, and double time for hours over 50.

o You have a list of contracts and due dates for annual maintenance fees. You wish to determine when you have a contract due in the next 45 days and provide a note that warns you that the payment is due.

Please feel free to add other, unique mathematical challenge questions to the discussion, and let us work together to figure out how you might calculate it.

Reference no: EM131565670

Questions Cloud

Explain which truth in sentencing impacts fair sentencing : Examine the fundamental manner in which proportionality and truth in sentencing impacts fair sentencing.
Discuss about flowcharting and data-flow diagrams : Your supervisor has just finished taking a college course in which she learned about flowcharting and data-flow diagrams
A deeper understanding of the contemporary issue : Explain how the theory provides a deeper understanding of the contemporary issue. Propose one well-developed solution to address the issue or problem.
An analysis of the federal response to natural disasters : The future of homeland security - an analysis of the past with a look to the future.
Create a formula to solve the scenario : Using the following scenarios, discuss how you would apply the Excel functions or create a formula to solve the scenario. Be specific!
Confidence intervals for estimating the population mean : Suppose that the standard deviation of the tube life for a particular brand of TV picture tube is known to be s = 500, but that the mean operating life.
Explore the different stages of the information processing : Explore the different stages (i.e., sensory store, filter, pattern recognition, selection, STM or LTM) of the information processing model (IPM).
The officer issued defendant a citation for impaired driving : The officer issued defendant a citation for impaired driving. Defendant filed a motion to suppress any evidence obtained as a result of her seizure and arrest
How would your answer change if x uses the optional method : If X does not use the optional method, when can it deduct the cost of the rotable part? How would your answer change if X uses the optional method

Reviews

Write a Review

Other Subject Questions & Answers

  Write thoughts about the importance of culture

Essay: Why Culture Matters For this assignment you will write an essay that explains your thoughts about the importance of culture in counseling

  Better places for non-leaders to work

Do you think so-called leadership factories are also better places for non-leaders to work? Why or why not?

  What does this behaviour tell us about person

what would be explanatory style of a person who makes internal, stable also global attributions for positive things also external, unstable also specific attributions for negative things. Also consider individual who does opposite.

  Describe the possible prevention and intervention ideas

Discuss the specific target area you want to address in the problem (in approximately 1 paragraph).Describe the specific group you want to focus on from among those affected by the criminal problem, i.e., juveniles, women, etc.Describe the possible p..

  Differences between this experiment and strange situation

What are the similarities and differences between this experiment and the Strange Situation we discussed in class? Do you think that this was an ethical way to conduct a research study

  Which specific foods provide the most fiber in a days meal

Review how your recorded protein, carbohydrate, and lipid intake compares with the recommendations of the DRI. If your recorded protein-carbohydrate-fat intake was too high or too low, which foods might you add or remove to achieve your goal and k..

  Analyze six provisions of the texas constitution

Analyze six provisions of the Texas Constitution, including two major provisions for each branch. You will need to research the criticisms and attempts to change major provisions of the Texas Constitution.

  Effects of quality management on domestic and global

Describe or diagram a process or procedure that is similar between the organizations. Explain the process or procedure from beginning to end.

  Develop three leading questions for each type of engagement

Choose four of the eight ways to engage and develop three leading questions for each type of engagement that will facilitate the work

  Identify major federal programs designed to help with the

in 2 double-spaced pages describe the range of services potentially needed by children with special health care

  Define the types of prostitution

Reasons contributing to a person becoming a prostitute.

  Write a one-paragraph analysis of reverend parris character

For this Apply, expand on the answer you wrote for #5 in your After Reading activities. Write a one-paragraph analysis of Reverend Parris's character

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd