Using the spreadsheet file that you created in Module 1,
identify the food items, for which portion amounts are recorded as greater than
‘1’ in your food log. In a new sheet, create one-variable data tables for these
food items. Data tables should calculate the amounts of calories relevant to
the number of portions. The input values for the number of portions should run
between ‘1’ and the value recorded in your food log. For example, if the number
of portions for some food item has been recorded as ‘5’ in your food log, then
input values in a data table would be integers from 1 to 5.
426194
6 minutes ago
Part 1 –
Setup Using this Template (XLSX), download create a food log that records your
meals and snacks for one day. Refer to the Food Table sheet of the template for
information on the total calories based on portion sizes for various food
items. For estimates of the amounts of calories, which you need to maintain
calorie balance, will depend on your age, sex, and one of three different
levels of physical activity, visit Dietary Guidelines. (Links to an external
site.) Consolidate identical food items with the same portion size.
Part 2 – Goal Seek
Identify the input and output cells for the formulas in your food log
table. Describe the relationship(s) between these cells. Based on your eating
habits/pattern you recorded, define your dietary goal. Use Goal Seek,
repeatedly, if necessary, to investigate what input values result in targeted
output. When documenting the Goal Seek process, be sure to describe the steps
and include any relevant illustrations. Submit both the Excel workbook and a
Word® document for this activity.
Discussion: Implications of Large Data Sets
The purpose of this discussion is to address the
implications of using large sets of data for performing meaningful analysis.
This assignment consists of two parts.
Section 1:
For your Excel Project assignment in this module, the
information on the total calories and portion sizes were structured as a table
of approximately 2,000 rows. One of the tasks this module week was to use this
table to search and retrieve required data. Now, imagine that you are dealing
with a 20,000-row table of data. While simple scrolling works for short tables,
this approach would be inefficient for searching through large amounts of data.
Using the Help feature of Excel, explore and discuss what Excel tools could be
used to accomplish these tasks in a more efficient manner.
Section 2:
The initial stages of any data analysis process are
collecting, accessing, and examining available data. Currently, most data
already exist in digital format. However, it is often found that raw data is
not suitable for immediate handling. Use your own experience or search the
Internet for reasons why such data may not be used directly. Identify potential
difficulties when importing large amounts of data into a spreadsheet format,
and discuss the principal activities for overcoming these problems.
Section II.
As you learned in Module 1, the initial stages of any data
analysis process
include collecting, exploring, and understanding data. These stages consist of actions for making
sure that the data is complete and converted
into a suitable format. Furthermore, what-if questions are formulated and relevant mathematical
models are being built. In this
module, you will construct and use data tables to estimate the calories needed to achieve your pre-set
dietary goal. Subsequently, you will
generate scenarios to understand the behavior of your model.
Part 1 – Data Table
Using the spreadsheet file that you created in Module 1,
identify the food items, for which portion amounts are recorded as greater than
‘1’ in your food log. In a new sheet, create one-variable data tables for these
food items. Data tables should calculate the amounts of calories relevant to
the number of portions. The input values for the number of portions should run
between ‘1’ and the value recorded in your food log. For example, if the number
of portions for some food item has been recorded as ‘5’ in your food log, then
input values in a data table would be integers from 1 to 5.
For
each previously selected food item, create a two-variable data table that
calculates the amounts of calories based on various portion sizes and the
number of portions. As in the previous step, the maximum number of portions
should agree with the corresponding value of the item in your food log
Part 2
– Scenarios
Using Scenario Manager, create a set of scenarios for projecting
the results of calculations in your food log table.
Note: Save the initial
values as “Original values” scenario.
Next,
in a new sheet, generate a scenario summary report.
Part 1 – Summary Report
In a document, using 3-4 sentences, explain the role of one
and two-variable data tables in a data analysis process as applied to your
model. Briefly describe your approach for building scenarios. Clarify whether
you chose to eliminate certain food items from your menu or to reduce the
portion sizes, and why. In 3-4 sentences, discuss whether a scenario summary
report contains all information necessary for making an adequate decision.
Submit both the Excel workbook and a Word document for this activity.
Discussion: Implications of Large Data Sets
As with any system, the output is only accurate when the input
is also accurate. A prime example is a two-variable data table. Consider
estimating peoples’ life expectancy. We may model it using the two-input
approach: one of the inputs would be blood pressure and the other input would
be age. However, any such correlation would only be a weak indicator
(meaningless output).
Consider
using a two-variable data table to determine calories required, with the energy
used and time spent doing the work as the table inputs. We may conclude that
there is a strong correlation between these two inputs. Therefore, we have high
confidence in the accuracy of the output value (meaningful output).
Using
the Internet resources, explore and discuss what requirements are available to
ensure a high confidence in the output and how you can determine if one of the
inputs is more significant than the other. Give one example of meaningless
correlation and one example of meaningful correlation.
Section 2:
The initial stages of any data analysis process are
collecting, accessing, and examining available data. Currently, most data
already exist in digital format. However, it is often found that raw data is
not suitable for immediate handling. Use your own experience or search the
Internet for reasons why such data may not be used directly. Identify potential
difficulties when importing large amounts of data into a spreadsheet format,
and discuss the principal activities for overcoming these problems.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|