Category: Excel

I will upload three excel files. You will have to make the first and the second table with the same formulas and editing as the third one. (Bolaffi 1999 and Bolaffi 1996 have to be the same format as Bolaffi 1997). They have to be equal to “Display Tab”.

1) Use the 3-month LIBOR as attached: 3month_LIBOR.xlsx ( 3month_LIBOR.xlsx ).
2) Download daily “3-month Treasury Constant Maturity Rate” from Jan. 2, 2019, to Dec 29, 2023. (https://fred.stlouisfed.org/series/DGS3MO) 3) Compute the daily average rate of return and standard deviation with a 3-month T-bill rate over the sample period,
4) Plot the cumulative rate of return (X-axis: Date, Y-axis: Cumulative Return) from 3). Explain the plot thoroughly. please explain how you did each part

Please watch the contents of the document carefully, especially the introductory video and workbooks

Data in the Excel File Microprocessor Data.xlsxshows the demand for one type of chip used in industrial equipment from a small manufacturer.
Construct a combo chart of the data. What appears to happen when a new chip is introduced?
Develop a causal regression model to forecast demand that includes both time and the introduction of a new chip as explanatory variables.
What would the forecast be for the next month if a new chip is introduced? What would it be if a new chip is not introduced?
Instructions:
Write your answer in a Microsoft Excel document. Include the data set. Criteria: 1. Chart of the data, 2. What appears to happen when a new chip is introduced? Conclusion from the chart,
3. Causal regression model Calculation tables and model, 4. Forecast be for the next month if a new chip is introduced, 5. Forecast be for the next month if a new chip is not introduced

For
this project, think of a situation in business/organization or in your personal
life where you can apply the analysis and tools we learned throughout the
semester to improve or automate decision-making. You can use
functions, pivot table, macros, as well as things beyond what you leaned in the
class.
The
goal is that application of these tools can help the business/organization to
run more efficiently or effectively. There are two general directions you can
take to achieve this goal:
·     
extract insights from data to help firm improve their operations
or make better decisions,
·     
automate certain operations so that it is easier for users/decision-makers
to search and access information or insights.
You
can pick one of them or do a hybrid of both.
Submission
Your
final submission should include an Excel file with your data and
analysis and a recorded presentation with slides that explain: 1. The
scenario 2. How your analysis/automation help with the business/organization. 
I
am grading your project mainly based on two aspects.
·     
The technical aspect: whether the tools you use is appropriate
for the analysis and the sophistication level of the tools
·     
The business aspect: whether you are solving a meaningful
problem (to aswer the “so what” question)

This work is already done I just need someone to me the excel sheet, same to the attached photo. The Lazer Company has a contract to produce a part for Boeing Corporation that must have an average diameter of 6 inches and a standard deviation of 0.10 inches. The Lazer Company has developed a process that will meet the specifications for the standard deviation, but it is still trying to meet the mean specifications. A test run (considered a random sample) of parts was produced, and the company wishes to determine whether this latest process that produced the sample will produce parts meeting the requirement of an average diameter equal to 6 inches.
Use Excel to:
Construct the appropriate null and alternative hypotheses with correct parameters.
Develop the decision rule assuming that the sample size is 200 parts and the significance level is 0.01.
In a Word document:
Recommend what the Lazer Company should conclude if the sample mean diameter for the 200 parts is 6.03 in

In the Personal Financial Plan last submitted under Project 4 turn to the Chapter 17 tab. You will be comparing different options for sector mutual funds. Please take a look at several mutual funds before choosing one. The Financial Times offers a very Once you have chosen a sector and mutual fund go through and answer each of the questions.https://markets.ft.com/data/funds/us https://money.usnews.com/funds/mutual-funds https://finance.yahoo.com/mutualfunds

I’ve put the intructions in a picture file next to my assignment. I need help to solve this. Everything is in the intructionss below

For this discussion it will be helpful to use the Chapter 18 section in the personal financial workbook but please do not share that here.
Discuss with your classmates what your strategy for asset allocation and diversification of investments would be. Based on the previous risk assessment what area would you heavily invest in? Where would you limit investments or not invest in at all? Would you choose to diversify your investments by choosing various global investments? Explain your reasoning for these choices. (1-2 para)

Open the Personal Financial Plan which should also be saved. Turn to the Chapter 19 tab. Complete the chart based on a conservative amount you plan to save each year once you are settled in your career. You are free to try out different contribution levels until you find one you are comfortable with. Once finished go through and reflect on each questions and when you will be able to retire. use the chapters that are complete in order to complete chapter 19 (ex: chap 1 is helpful)