Assignment: Capella University General Dynamics Corporation Data Excel Worksheet
Assignment: Capella University General Dynamics Corporation Data Excel Worksheet
Question Description
I am very frustrated by my inability to get the information in need in the vertical and horizontal bar. While I can create the scatter plot etc.. changing the data has become an excersize in insanity as I keep doing the samething over and over again expecting a different result! How do I do this?
Select a business of which you are a part or in which you have interest and download the raw data on the company’s stock history. Any business that has practical meaning for you is appropriate for this assessment.
Follow these steps to locate and download stock history from Yahoo! Finance:
Go to Yahoo Finance.
Search for and find the stock of the company you have chosen.
Click on the “Historical Data” tab. Then select the following settings above the table:
Select Time Period of one year.
Select “Historical Prices.”
Select Frequency as “Daily.”
Click Apply.
Click on “Download Data.” Go to the bottom of your screen or your Downloads folder to open the Excel file you just downloaded. Open the Excel file. Check to be sure that you have enough lines to show the whole year. If not, reset the settings at the top of the Historical Data chart and try again.
Once you are sure that you have a year’s worth of data, save the Excel file.
Using the Excel file with the year’s stock data, conduct descriptive analysis as follows:
Create a scatterplot of the highest stock price (in the column labeled “High”) against time. Write a sentence explaining the process by which you created this graph.
Create a scatterplot of the lowest stock price (in the column labeled “Low”) against time. Write a sentence explaining the process by which you created this graph.
Create a histogram of the adjusted daily closing stock price (in the column labeled “Adj Close”). Make sure the histogram is meaningful by adjusting the bin size so you can see the shape of the histogram. Write a sentence explaining the process by which you created this graph.
Create a histogram of the stock trading volume (in the column labeled “Volume”). Make sure the histogram is meaningful by adjusting the bin size so you can see the shape of the histogram. Write a sentence explaining the process by which you created this graph.
Calculate the mean, median, mode, and standard deviation of the adjusted daily closing stock price. Write a sentence explaining the process by which you calculated these statistics.
Calculate the mean, median, mode, and standard deviation of the stock volume. Write a sentence explaining the process by which you calculated these statistics.
Prepare a report that you would present to your supervisor, including the following:
An APA-formatted title page.
A one-page introduction of your chosen company, including the company background and practical business context.
A section headed Graphical Representations of Data, in which you include the four graphs you created above and a summary of the processes by which you created each graph.
A section headed Descriptive Statistics, in which you include the statistics you calculated above and and a summary of the procedures you followed to calculate the statistics.
APA-formatted in-text citations and a corresponding references page. Remember to cite the source of your financial data.
Walkthrough: You may view the following media piece to help you understand concepts addressed in this assessment:
Using Analytic Techniques to Add Meaning to Data Walkthrough.
ADDITIONAL REQUIREMENTS
Length: 3–5 pages, double-spaced. Include a title page and the graphical representations of the data selected.
Written communication: free of errors that detract from the overall message.
EVALUATION
By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies through corresponding scoring guide criteria:
Competency 2: Use analytic and statistical techniques to make meaning of large quantities of data.
Create four different graphical representations of data.
Calculate descriptive statistics for two different variables.
Summarize the processes by which each graph and statistics were created and calculated.
Competency 4: Present the results of data analysis in clear and meaningful ways to multiple stakeholders.
Introduce the company and practical business context.
Correctly format citations and references using current APA style.
Write content clearly and logically with correct use of grammar, punctuation, and mechanics.
Struggling to meet your deadline ?
Get assistance on
Assignment: Capella University General Dynamics Corporation Data Excel Worksheet
done on time by medical experts. Don’t wait – ORDER NOW!
You must proofread your paper. But do not strictly rely on your computer’s spell-checker and grammar-checker; failure to do so indicates a lack of effort on your part and you can expect your grade to suffer accordingly. Papers with numerous misspelled words and grammatical mistakes will be penalized. Read over your paper – in silence and then aloud – before handing it in and make corrections as necessary. Often it is advantageous to have a friend proofread your paper for obvious errors. Handwritten corrections are preferable to uncorrected mistakes.
Use a standard 10 to 12 point (10 to 12 characters per inch) typeface. Smaller or compressed type and papers with small margins or single-spacing are hard to read. It is better to let your essay run over the recommended number of pages than to try to compress it into fewer pages.
Likewise, large type, large margins, large indentations, triple-spacing, increased leading (space between lines), increased kerning (space between letters), and any other such attempts at “padding” to increase the length of a paper are unacceptable, wasteful of trees, and will not fool your professor.
The paper must be neatly formatted, double-spaced with a one-inch margin on the top, bottom, and sides of each page. When submitting hard copy, be sure to use white paper and print out using dark ink. If it is hard to read your essay, it will also be hard to follow your argument.
ADDITIONAL INSTRUCTIONS FOR THE CLASS
Discussion Questions (DQ)
Initial responses to the DQ should address all components of the questions asked, include a minimum of one scholarly source, and be at least 250 words.
Successful responses are substantive (i.e., add something new to the discussion, engage others in the discussion, well-developed idea) and include at least one scholarly source.
One or two sentence responses, simple statements of agreement or “good post,” and responses that are off-topic will not count as substantive. Substantive responses should be at least 150 words.
I encourage you to incorporate the readings from the week (as applicable) into your responses.
Weekly Participation
Your initial responses to the mandatory DQ do not count toward participation and are graded separately.
In addition to the DQ responses, you must post at least one reply to peers (or me) on three separate days, for a total of three replies.
Participation posts do not require a scholarly source/citation (unless you cite someone else’s work).
Part of your weekly participation includes viewing the weekly announcement and attesting to watching it in the comments. These announcements are made to ensure you understand everything that is due during the week.
APA Format and Writing Quality
Familiarize yourself with APA format and practice using it correctly. It is used for most writing assignments for your degree. Visit the Writing Center in the Student Success Center, under the Resources tab in LoudCloud for APA paper templates, citation examples, tips, etc. Points will be deducted for poor use of APA format or absence of APA format (if required).
Cite all sources of information! When in doubt, cite the source. Paraphrasing also requires a citation.
I highly recommend using the APA Publication Manual, 6th edition.
Use of Direct Quotes
I discourage overutilization of direct quotes in DQs and assignments at the Masters’ level and deduct points accordingly.
As Masters’ level students, it is important that you be able to critically analyze and interpret information from journal articles and other resources. Simply restating someone else’s words does not demonstrate an understanding of the content or critical analysis of the content.
It is best to paraphrase content and cite your source.
LopesWrite Policy
For assignments that need to be submitted to LopesWrite, please be sure you have received your report and Similarity Index (SI) percentage BEFORE you do a “final submit” to me.
Once you have received your report, please review it. This report will show you grammatical, punctuation, and spelling errors that can easily be fixed. Take the extra few minutes to review instead of getting counted off for these mistakes.
Review your similarities. Did you forget to cite something? Did you not paraphrase well enough? Is your paper made up of someone else’s thoughts more than your own?
Visit the Writing Center in the Student Success Center, under the Resources tab in LoudCloud for tips on improving your paper and SI score.
Late Policy
The university’s policy on late assignments is 10% penalty PER DAY LATE. This also applies to late DQ replies.
Please communicate with me if you anticipate having to submit an assignment late. I am happy to be flexible, with advance notice. We may be able to work out an extension based on extenuating circumstances.
If you do not communicate with me before submitting an assignment late, the GCU late policy will be in effect.
I do not accept assignments that are two or more weeks late unless we have worked out an extension.
As per policy, no assignments are accepted after the last day of class. Any assignment submitted after midnight on the last day of class will not be accepted for grading.
Communication
Communication is so very important. There are multiple ways to communicate with me:
Questions to Instructor Forum: This is a great place to ask course content or assignment questions. If you have a question, there is a good chance one of your peers does as well. This is a public forum for the class.
Individual Forum: This is a private forum to ask me questions or send me messages. This will be checked at least once every 24 hours.
Struggling to meet your deadline ?
Get assistance on
Assignment: Capella University General Dynamics Corporation Data Excel Worksheet
done on time by medical experts. Don’t wait – ORDER NOW!