For this task, you need to download 4-time series from Yahoo! Finance website: Any student should have their own unique set of time series!
Please collect available data for three years 2018-2020
Please pay attention that for your analysis the time moments should be sorted from oldest to newest. Use the daily closing price.
Software test plans identify specific features that need to be tested, how they need to be tested, and to what extent they need to pass the identified tests.
Respond to the following in a minimum of 175 words:
Discuss in 500 words or more federated architecture in cloud systems. Remember that this is a cloud class not a database class.
Use at least three sources. Use the Research Databases available from the Danforth Library not Google. Include at least 3 quotes from your sources enclosed in quotation marks and cited in-line by reference to your reference list. Example: “words you copied” (citation) These quotes should be one full sentence not altered or paraphrased. Cite your sources using APA format. Use the quotes in your paragaphs. Stand alone quotes will not count toward the 3 required quotes.
Exp22_Excel_Ch02_Cumulative – Garten Furniture
Exp22 Excel Ch02 Cumulative – Garten Furniture
Excel Chapter 2 Cumulative – Furniture Sales
You are a finance manager for Garten furniture, a local furniture store that also provides financing, delivery, and hands free setup. As part of your daily tasks, you create an Excel workbook that reports sales, payment plan information, and summary statistics.
Start Excel. Download and open the file named Exp22_Excel_Ch02_Cumulative_Furniture_Sales.xlsx. Grader has automatically added your last name to the beginning of the filename.
Insert a function in cell C3 to display the current date and ensure that the format is set as a Long Date.
Set column C’s width to Autofit.
Insert a function in cell D11 to display the item name based on the provided inventory lookup information in the range B24:D29. Be sure to use the appropriate absolute cell referencing and the function returns an exact match. Copy the function from cell D11 down through D19 to complete column D.
Insert a function in cell F11 to display the item price based on the provided inventory lookup information. Be sure to use appropriate absolute cell referencing and the function returns an exact match. Copy the function from cell F11 down through F19 to complete column F.
Apply Currency Format to column F.
Insert an IF function in cell G11 to calculate the total due. If the customer has chosen delivery (column E = Yes), there is an additional delivery charge located in cell L11. If the item is not delivered, the total due is price. Be sure to use appropriate relative and absolute cell references. Copy the function from cell G11 down through G19 to complete column G.
Apply Currency format to column G.
Insert the function in cell I11 to calculate the first customer’s monthly payment, using appropriate relative and absolute cell references. Place a minus sign to the left of the present value argument so that the function returns a positive result. Copy the formula down the column.
Use Quick Analysis to insert a function in cell I20 that calculates the total of all monthly payments in column I.
Apply Currency Format to column I.
Type the customer name McGowan in cell B6.
Use the XLOOKUP function in cell C6 to lookup the customer name in the worksheet and return the corresponding SKU, item name, delivery option, price, total due, years financed, and monthly payment.
Use Format Painter to copy the format from the range C11:I11 to C6:I6.
Insert a function in cell H24 to calculate the total number of orders in the SKU column.
Insert a function in cell H25 to calculate the lowest monthly payment in column I.
Insert a function in cell H26 to calculate the average monthly payment in column I.
Insert a function in cell H27 to calculate the highest monthly payment in column I.
Insert a function in cell H28 to calculate the median monthly payment in column I.
Apply Currency format to the range H25:H28.
Save and close Exp22_Excel_Ch02_Cumulative_Furniture_Sales.xlsx. Exit Excel. Submit the file as directed
1) project, and its main attributes
2) day-to-day jobs
Provide examples to illustrate the importance of these items and Discuss the unique challenges that an IT project presents.
Discussion:
What is thought? Discuss.
Materials:
Brains, Minds, and Machines: Language and Thought – YouTube
What Is a Thought? | Psychology Today (Links to an external site.) [https://www.psychologytoday.com/us/blog/consciousness-and-the-brain/201202/what-is-thought]
respond with two (2) students/Peers to Peer (identify peers) or two classmates.
1. You are to write a Java program that prompts a user to enter a Java character, determines the group of the entered character, and displays the result.
2. In simple term, the characters may be grouped as the following:
1. Lowercase characters
2. Uppercase characters
3. Digits
4. Punctuation marks
5. White spaces
6. Special characters.
Instructions
Week 6 Assignment:
In order to complete assignment #6 you will need to answer the below questions. Please complete the questions in a Word document and then upload the assignment for grading. When assigning a name to your document please use the following format (last name_Assignment #1). Use examples from the readings, lecture notes and outside research to support your answers. The assignment must be a minimum of 1-full page in length with a minimum of 2 – outside sources. Please be sure to follow APA guidelines for citing and referencing source. Assignments are due by 11:59 pm Eastern time on Sunday.
Instructions:
Discuss three tools used for Windows Backup and Restore using the text, Internet, and/or your job as reference for full credit
In this project, you will make narrated presentation to convince the BallotOnline management of the value of migrating the organization’s existing IT infrastructure and services to a public cloud. You will learn about cloud computing technology and services and how organizations can take advantage of this trend.Your supervisor, Sophia, BallotOnline’s director of information technology, has tasked you with creating a presentation that will convince the executives that using cloud-based computing to accommodate Ballot Online future growth rather than trying to expand the current infrastructure will help the company do business faster and at lower cost while conserving IT resources. Question: you will prepare your presentation for the Ballot Online executives. This presentation should present them with a compelling business case and cover the benefits and possible drawbacks of adopting cloud infrastructure, data on cloud economics, and a demo of some basic cloud capabilities. Your presentation will include an executive summary along with the following steps:
Please use power point to answer the question and add references
