{"id":104917,"date":"2022-08-08T00:00:00","date_gmt":"2022-08-08T00:00:00","guid":{"rendered":"https:\/\/nursingstudybay.com\/2022\/08\/08\/creating-a-database-using-microsoft-excel\/"},"modified":"2022-08-08T00:00:00","modified_gmt":"2022-08-08T00:00:00","slug":"creating-a-database-using-microsoft-excel","status":"publish","type":"post","link":"https:\/\/www.studyproessays.com\/help\/creating-a-database-using-microsoft-excel\/","title":{"rendered":"Creating a Database using Microsoft Excel"},"content":{"rendered":"<p>Creating a Database using Microsoft Excel<br \/>\nCreate a new Microsoft Excel database in which you will be able to enter the following variables:<\/p>\n<p>Subject identification (ID) number<br \/>\nAge.  (my age is 27)<br \/>\nSex (female)<br \/>\nHeight (5&#8217;3)<br \/>\nYear in college (4th year in prison)<br \/>\nName each variable in the datafile. All data to be manipulated (everything except the participant ID number) must be entered as numeric values.<\/p>\n<p>Create data for forty hypothetical students who are undergraduates in college, making sure you have five males and five females in each year (freshman, sophomore, junior, and senior):<\/p>\n<p>Subject ID number (You will be required to provide this yourself. For example, subject 1 is P1; subject 2 is P2, and so forth. This should be entered as alphanumeric in your database since it is not a variable we will use in any of our data analyses).<br \/>\nAge: Be sure to get variability in your data. Not all students in any given year are of the same age. Be realistic with your data.<br \/>\nSex: Assign a number for each of Male and Female and provide clarification as to what each number refers to as demonstrated in your lectures.<br \/>\nHeight (convert to inches; 5 feet 3 inches = [12 * 5] + 3 = 63). Enter the number 63, not the formula.<br \/>\nYear in college (freshman, sophomore, junior, or senior). Assign a number for each year and provide clarification as to what each number refers to as demonstrated in your lectures.<br \/>\nEnter the complete dataset into the Microsoft Excel worksheet. Save the workbook on your hard drive.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Creating a Database using Microsoft Excel Create a new Microsoft Excel database in which you will be able to enter the following variables: Subject identification\u2026<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8981,8978,8975,7725,8985,8980,7726,8973,8986,8972,8974,8979,8984,8977,8983,8976,8982],"tags":[9010,9013,2760,107,9011,9009,7569,9012],"class_list":["post-104917","post","type-post","status-publish","format-standard","hentry","category-best-custom-paper-writing-service","category-best-online-paper-writing-service","category-best-paper-writing-service","category-best-research-paper-writing-services","category-cheap-research-paper-writing-service","category-cheapest-paper-writing-service","category-college-paper-writing-service-cheap","category-free-paper-writing-service","category-free-term-paper-writing-service","category-paper-writing-service","category-paper-writing-service-reddit","category-professional-paper-writing-service","category-someone-to-write-my-paper","category-websites-that-write-papers-for-you","category-what-is-the-best-paper-writing-service","category-write-my-paper","category-write-my-paper-for-me-free","tag-best-cheap-essay-writing-services","tag-cheap-essay-writer-uk","tag-cheap-essay-writing-service-uk","tag-cheap-essay-writing-services","tag-cheap-personal-essay-writing-website-for-school","tag-cheapest-essay-writing-service","tag-free-essay-typer","tag-introduction-paragraph-generator"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/104917","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=104917"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/104917\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=104917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=104917"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=104917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}