Category: Excel

Should have latest Microsoft package.
Use the Recommend Charts feature t

Should have latest Microsoft package.
Use the Recommend Charts feature to create 5 different charts for the table below.
Add those charts to this sheet.
Which one is the best and why? Add your reply below

Name Company Year 1 Year 2 Year 3
Sarah A. Raymond IBM $ 497,056 $ 459,442 $ 240,201
Driscoll P. Randolph IBM $ 224,056 $ 343,691 $ 386,250
Giselle V. Duncan Oracle $ 162,898 $ 224,564 $ 224,519
Meghan H. Ramsey Google $ 438,383 $ 213,499 $ 389,179
Selma B. Crane Cisco $ 215,371 $ 407,764 $ 154,175
Orli H. Howe Cisco $ 471,865 $ 449,041 $ 309,239
Kellie S. Houston IBM $ 200,495 $ 134,570 $ 119,288
Ginger S. Griffith Oracle $ 473,899 $ 227,097 $ 285,756
Derek E. Howell Google $ 169,095 $ 298,539 $ 104,795
Hillary C. Rich Cisco $ 386,959 $ 197,669 $ 162,189
Raya B. Black Google $ 264,518 $ 441,014 $ 120,831
Callie Q. Campbell Oracle $ 493,440 $ 396,792 $ 464,680
Ayanna K. Boyle Google $ 191,224 $ 482,042 $ 455,967
Virginia Z. Gardner Oracle $ 199,978 $ 328,868 $ 114,766

Use the Recommend Charts feature to create 5 different charts for the tab

Use the Recommend Charts feature to create 5 different charts for the table below.
Add those charts to this sheet.
Which one is the best and why? Add your reply below

Name Company Year 1 Year 2 Year 3
Sarah A. Raymond IBM $ 497,056 $ 459,442 $ 240,201
Driscoll P. Randolph IBM $ 224,056 $ 343,691 $ 386,250
Giselle V. Duncan Oracle $ 162,898 $ 224,564 $ 224,519
Meghan H. Ramsey Google $ 438,383 $ 213,499 $ 389,179
Selma B. Crane Cisco $ 215,371 $ 407,764 $ 154,175
Orli H. Howe Cisco $ 471,865 $ 449,041 $ 309,239
Kellie S. Houston IBM $ 200,495 $ 134,570 $ 119,288
Ginger S. Griffith Oracle $ 473,899 $ 227,097 $ 285,756
Derek E. Howell Google $ 169,095 $ 298,539 $ 104,795
Hillary C. Rich Cisco $ 386,959 $ 197,669 $ 162,189
Raya B. Black Google $ 264,518 $ 441,014 $ 120,831
Callie Q. Campbell Oracle $ 493,440 $ 396,792 $ 464,680
Ayanna K. Boyle Google $ 191,224 $ 482,042 $ 455,967
Virginia Z. Gardner Oracle $ 199,978 $ 328,868 $ 114,766

Create a map chart based on the data below.
Place the chart on this shee

Create a map chart based on the data below.
Place the chart on this sheet.
Make sure to add a title to the chart.

State Number of Orders
Oklahoma 25
California 47
Pennsylvania 79
Illinois 55
Nevada 114
Florida 25
Texas 42
Ohio 147
North Carolina 111
Minnesota 117
Virginia 132
District of Columbia 43
Florida 66
Missouri 61
New York 88
California 69
Washington 26

Hide Folder Information
Instructions
For a demonstration, see https://www.youtub

Hide Folder Information
Instructions
For a demonstration, see https://www.youtube.com/watch?v=knmOmEuFO1k&t=86s
Lab7 starter file is attached
Lab 7 Purpose
To demonstrate Microsoft Excel, including formulas, functions, graphs, autofill, autosum, graphs, header, etc.
l
Lab 7 Criteria
File zipped with proper name (5%)
Zip contains folder (5%)
Folder has proper name (5%)
Folder contains xlsx file with proper name (5%)
File contains completed introductory activities at the top of the sheet  (5%)
File contains proper months (5%)
File contains completed income row (5%)
File contains completed income totals (5%)
File contains completed expense rows (5%)
File contains completed expense totals, by month and grand total (10%)
File contains a formula to take income and subtract from it expenses for each month (10%)
File contains a chart based,  on just income-expenses (10%)
File contains proper header (5%)
Appropriately saved and submitted (20%)
BONUS
Select sheet2; create your own budget.
Make sure to have at least two kinds of income
total by month and by income type
Make sure to have at least four kinds of expenses
total by month and by income type
Take each months total income and subtract from it each month’s total expenses
Make a chart based on the monthly profit
Add a header
Remove my instructions from sheet2
Change the format colors
When finished with sheet2, File>Save As>yourname-my-budget.xlsx in the lab7 folder
Refer to sheet1 if you can’t remember how to do any of the steps.
Close excel
Browse to the lab7 folder, right click and compress, naming it yourname-lab7.zip
Submit
You will may wind up with 2 files, yourname-budget.xlsx and yourname-my-budget.xlsx; 
Zip the folder that contains those two files, and rename the zip yourname-lab7.zip
Help with D2L, updated

As you begin exploring rehabilitation this week, this Discussion Spark is intend

As you begin exploring rehabilitation this week, this Discussion Spark is intended to get you thinking about how the public views rehabilitated offenders, and how comfortable the public is with rehabilitated offenders living in their communities and neighborhoods.
To Prepare:
Think about your neighborhood and community values.
Consider whether you think prior offenders could adhere to the values of your neighborhood or community.
Consider how comfortable you are with a prior offender living next door to you.
Do you want a released offender living as your next-door neighbor? Why or why not?
If yes, how could you help that offender become a member of the community?
If no, what makes you uneasy about that offender living next door?
Are there certain types of offenders you would be more comfortable living next to than others? Which ones and why?

The use of solitary confinement is debated. Some say it is a necessary tool for

The use of solitary confinement is debated. Some say it is a necessary tool for correctional facilities while others argue that it is cruel and usual punishment.

Hide Folder Information
Instructions
For a demonstration, see https://www.youtub

Hide Folder Information
Instructions
For a demonstration, see https://www.youtube.com/watch?v=knmOmEuFO1k&t=86s
Lab7 starter file is attached
Lab 7 Purpose
To demonstrate Microsoft Excel, including formulas, functions, graphs, autofill, autosum, graphs, header, etc.
l
Lab 7 Criteria
File zipped with proper name (5%)
Zip contains folder (5%)
Folder has proper name (5%)
Folder contains xlsx file with proper name (5%)
File contains completed introductory activities at the top of the sheet  (5%)
File contains proper months (5%)
File contains completed income row (5%)
File contains completed income totals (5%)
File contains completed expense rows (5%)
File contains completed expense totals, by month and grand total (10%)
File contains a formula to take income and subtract from it expenses for each month (10%)
File contains a chart based,  on just income-expenses (10%)
File contains proper header (5%)
Appropriately saved and submitted (20%)
BONUS
Select sheet2; create your own budget.
Make sure to have at least two kinds of income
total by month and by income type
Make sure to have at least four kinds of expenses
total by month and by income type
Take each months total income and subtract from it each month’s total expenses
Make a chart based on the monthly profit
Add a header
Remove my instructions from sheet2
Change the format colors
When finished with sheet2, File>Save As>yourname-my-budget.xlsx in the lab7 folder
Refer to sheet1 if you can’t remember how to do any of the steps.
Close excel
Browse to the lab7 folder, right click and compress, naming it yourname-lab7.zip
Submit
You will may wind up with 2 files, yourname-budget.xlsx and yourname-my-budget.xlsx; 
Zip the folder that contains those two files, and rename the zip yourname-lab7.zip
Help with D2L, updated

Construct a simulation model of the Mockingbird Airlines system. Each iteration of your simulation should assign a random number of shows/no-shows based on a binomial distribution.

This assignment builds off of the Overbooking case study from Chapter 9 in the Clemen and Reilly text.
Your task: submit a single excel spreadsheet with the following:
1. Construct a simulation model of the Mockingbird Airlines system. Each iteration of your simulation should assign a random number of shows/no-shows based on a binomial distribution.
2. Mockingbird needs to decide between selling 16, 17, 18, or 19 seats per flight. Run your simulation 1,000 times for each possible decision and gather the results (i.e., the profit for each run).
3. Provide a table with the average profit and standard deviation of the profit for each of the four possible choices.
4. Expand your simulation model to include uncertainties for the no-show rate and the cost per bumped passenger. Model the no-show rate as a uniform distribution between 0.02 and 0.06. Instead of a fixed $225 + $100 per bumped passenger, model the cost per bumped passenger as a normal distribution with a mean of $300 and and standard deviation of $40.
5. Provide a table with the average profit and standard deviation of the profit for each of the four possible choices.

A link to the TiVo case, Read the case carefully and complete exercises 3-9 at t

A link to the TiVo case, Read the case carefully and complete exercises 3-9 at the end of the case. Ignore the prompt in Question 9, instead analyze the entire market research process outlined in the case, and comment on your segmentation schemes in the Excel file. Make sure to explain what your results mean to managers.
As you write your analysis, focus on what value TiVo provides to its customers and how you might best measure that. Think about the following: Does the study presented in the case do a good job of evaluating consumer attitudes? What are the strengths and weaknesses of the present approach? Would you have done anything differently in the market research project? If so, what would you have done and what would you expect to find? Why would you want to segment your market in the first place; what is the best way to do so? How do the different kinds of research you might do relate to each other? What was your rationale for choosing the segments you chose, and how do you think TiVo can approach those segments/customers?
You must turn in your answers and calculations for questions 3-9; you may use whatever analysis program you are comfortable with (python, r, Google Sheets, and Microsoft Excel are all acceptable). Your submission will be the completed Microsoft Excel file.
The analysis part will be assessed with #MarketAnalytics and your narratives with #CustomerCentricity.
Hint: If you are unfamiliar with wrangling data, pivot tables will be your friend. You may want to check out chapter 1 of “Marketing analytics: Data-driven techniques with Excel”

Case 1 – [Company’s] Purchase Decision
This case is a simple capital budgeting e

Case 1 – [Company’s] Purchase Decision
This case is a simple capital budgeting exercise that should reinforce your understanding of the
following topics:
• Incremental unlevered net income
• Free cash flow
• Sensitivity analysis and scenario analysis
In this exercise you will choose the company that is making the purchase decision. The company
needs to be a publicly traded company. I would recommend that you choose a company in an
industry that you have experience with or a company that you find personally interesting.
BOTH MATERIALS NEEDED FOR INSTRUCTIONS AND EXCEL TEMPLATE ARE ATTACHED.
Thank you