- Present the key descriptive statistics for the five quantitative variables in a table (quantity sold, advertising expenses, flavor rating, social media posts, and event promotions). The key descriptive statistics include the mean, median, standard deviation, and range.
- Analyze the TC Ice Cream data to identify trends and patterns for the two flavors you have selected. For each flavor, create the following visualizations.
- Create a line chart (also known as a trend chart) using the qualitative variable Date and the quantitative variable Quantity Sold to provide a visualization displaying quantity sold by month.
- Create a line chart (also known as a trend chart) using the qualitative variable Date and the quantitative variable Flavor Rating (average) to provide a visualization displaying flavor rating (average) by year/quarter/month.
- Create a combo chart using the qualitative variable Date (x-axis) and the quantitative variables: Quantity Sold (clustered column) and Advertising expenditures (line – secondary axis).
- Create a combo chart using the qualitative variable Date (x-axis) and the quantitative variables: Quantity Sold (clustered column) and total – Social Medial Posts and Event Promotions (line – secondary axis). Hint: create a pivot table variable to sum the social media posts and event promotions.
- Create a box and whiskers chart using the qualitative variable Quantity Sold. This will help identify any outliers in the quantity sold data.
- Create a histogram for the quantitative variable Flavor Rating. It is recommended to use the data analysis “add-in” and the analysis tool “Histogram” to create the data for the visualization.
- WE OFFER THE BEST CUSTOM PAPER WRITING SERVICES. WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU.
- Assignment status: Qualitative variable Date and the quantitative variable Quantity Sold to provide a visualization displaying quantity sold by month
- Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
Tag: visualization
Doreen is delivering a speech on the topic of donating money to help feed the children of AIDS victims in Africa. She set up her speech using Monroe’s motivated sequence. She sails through attention, needs, and satisfaction. She starts delivering her visualization step, and she goes a little crazy. She claims that if more people would donate to this cause, the world would be devoid of hunger, children in Africa could all get an education, and we could establish world peace. She then makes claims that not feeding the children of AIDS victims in Africa could lead to world chaos and nuclear war.1. Is it ethical to create unrealistic expectations during the visualization step?2. Should you try to exaggerate the visualization stage if you know, realistically, that the possible outcomes are not that impressive?3. If Doreen was your friend, how would you respond to this section of her speech? Should you point out that her argument is unethical? Virginia is asked to roast one of her bosses at the annual company meeting. Virginia collects a range of stories from people about her boss and a few of them are definitely quite embarrassing. She finds out about her boss ex-husband and some of the marital difficulties they had that are quite funny. She also finds out that when her boss broke her leg, it actually happened while sliding down a slide and not on a ski trip as she had told her office. As Virginia prepares her speech, she starts questioning what information she should use and what information is going too far.1. How should a roaster ethically go about collecting funny stories for his or her roast?2. What type of information would be ethical for a roaster to use? What type of information would be unethical for a roaster to use?3. At what point does a roast go from being good-natured to being meanspirited?
WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU
GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class on
Is it ethical to create unrealistic expectations during the visualization step?
Assessment Description
The purpose of this assignment is to use fundamental visualization software techniques to analyze data and tell the data story.
Problem
Open Tableau and connect to the \\\”RentalData\\\” worksheet in the \\\”Rental Data\\\” file.
The \\\”Rental Data\\\” file contains data on car rental activity for a specialty rental car company, whose customer base is only college students. Note for the \\\”Insurance\\\” field 1 = customer purchased rental insurance, and 0 = customer did not purchase rental insurance. The \\\”InputData\\\” worksheet provides a description of each \\\”CarID\\\” code. \\\”TimeOut\\\” is measured in hours, and \\\”Price\\\” is dollar amount charged for the rental. The \\\”Note\\\” field includes the general condition of the rented car upon its return. The remaining fields in the \\\”RentalData\\\” worksheet are self-explanatory.
Create the following charts/tables using Tableau. Charts/Tables will be based on the \\\”RentalData\\\” worksheet in the \\\”Rental Data\\\” file. Place each chart/table into a separate sheet in your Tableau file.
- Column Chart: Sum of Miles by CarID. Ensure that the column bars are purple and that the mileage values are above each column. Name the Tableau sheet \\\”MilesbyCarID.\\\”
- Pie Chart: Percentage Time out by \\\”Standing.\\\” Ensure that the percentage values for each pie piece are displayed on the chart. Name the Tableau sheet \\\”TimeOutbyStanding.\\\”
- Scatter Chart: Time Out by Price. Ensure \\\”TimeOut\\\” is the x variable, and \\\”Price\\\” is the y variable. Name the Tableau sheet \\\”TimeOutbyPrice.\\\”
- Horizontal Bar Chart: Time Out by Car ID by Month. Ensure that the horizontal bars are green and that the time out values are to the right of each column. Partition the chart by month. Name the Tableau sheet \\\”TimeOutbyCarID.\\\”
- Text Table: Count of Notes by Gender by Standing by Insurance. Ensure that the counts are blue. Name the Tableau sheet \\\”NotebyGenderbyStandingbyIns.\\\”
- Treemap Chart: Count of Notes by Standing. Select your own colors for the treemap. Name the Tableau sheet \\\”NotebyStanding.\\\”
- Packed Bubbles Chart: Miles by CarID by Insurance. Select your own colors for the chart (one color for each \\\”Insurance\\\” category). The size of the bubbles should be based on mileage for each \\\”CarId.\\\” Display the \\\”CarID\\\” inside each bubble. Name the Tableau sheet \\\”MilesbyCarIDbyInsurance.\\\”
- Area Chart: Miles by Month. Select your own colors for the chart (one color for each area). Display the \\\”Miles\\\” values on the chart. Name the Tableau sheet \\\”MilesbyMonth.\\\”
For each required item above, take note of the results. The insights gained from this information will need to be summarized in a PowerPoint presentation that will be submitted as a part of this assignment. You are required to submit the completed Tableau *.twb file and the Excel file containing the source data to your instructor. Create a .zip file that contains your Tableau file and any other supporting files. Submit your .zip file. Ensure that your last name is in the filenames
WE HAVE DONE THIS ASSIGNMENT BEFORE, WE CAN ALSO DO IT FOR YOU
GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class
CLICK HERE TO MAKE YOUR ORDER on Fundamental visualization software techniques to analyze data and tell the data story
Categories
Big Data Visualization tools
Several Big Data Visualization tools have been evaluated in this weeks paper. While the focus was primarily on R and Python with GUI tools, new tools are being introduced every day. Compare and contrast the use of R vs Python and identify the pros and cons of each. Provide an example of both programming languages with coding examples as well as your experience in using one or both programming languages in professional or personal work. If you have no experience with either language, please discuss how you foresee using either/both of these languages in visualizing data when analyzing big data.
A substantive post will do at least two of the following:
- Ask an interesting, thoughtful question pertaining to the topic
- Answer a question (in detail) posted by another student or the instructor
- Provide extensive additional information on the topic
- Explain, define, or analyze the topic in detail
- Share an applicable personal experience
- Provide an outside source (for example, an article from the University Library) that applies to the topic, along with additional information about the topic or the source (please cite properly in APA)
- Make an argument concerning the topic.
At least one scholarly source should be used. Be sure to use information from your readings and other sources from the University Library. Use proper citations and references in your post.
A picture is worth a thousand words” may be a lovely cliché, but it’s exactly the wrong way to view visualization. For this week’s discussion question, please view the Periodic Table of Visualization at the following link (http://www.visual-literacy.org/periodic_table/periodic_table.html). Choose one Data Visualization and one Compound Visualization by placing your mouse cursor over each option. Provide your classmates with a brief description of your choices and explain why you made your choices. Also, describe what advantages do your choices have over the others.